Hello Dear
Try To concatenate using & operator.
If u want to concatenate a1 and b1 then try to use
=a1&"/"&b1
Hope It Will Help
Happy To Help
:)
Shyam
On Fri, Mar 12, 2010 at 11:21 AM, Abhishek Jain wrote:
> Dear Ayush,
>
> Thanks.
>
> I thought of this but in Summary sheet I would have
Dear Ayush,
Thanks.
I thought of this but in Summary sheet I would have to manually select (or
type) the range of each sheet in Vlookup formula. Also I would have to make
a combined column in each sheet. Like I said there are around 66 sheets and
writing vlookup and make an additional column in e