Dear Vivek,
Please find attached example sheet of Global Vlookup.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Mon, Jun 11, 2012 at 8:59 AM, Vivek wrote:
> How to use the Vlookup function in a separate excel file, to search for
> file number f
How to use the Vlookup function in a separate excel file, to search for
file number form the client index file, where data are stored in multiple
sheets.
On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote:
> I have created a file index , with separate sheets alphabetically.
>
>
>
> Now I
Please replace previous
Please see attached
2012/6/9 ChilExcel :
> Please see attached
>
> 2012/6/9 Vivek :
>>
>> Dear All,
>> Please find enclosed herewith the sample file.
>> Thanks
>> CA Vivek Jain.
>>
>> On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote:
>>>
>>> I have created a file index
Please see attached
2012/6/9 Vivek :
>
> Dear All,
> Please find enclosed herewith the sample file.
> Thanks
> CA Vivek Jain.
>
> On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote:
>>
>> I have created a file index , with separate sheets alphabetically.
>>
>>
>>
>> Now I want to use the vlooku
YOu could use something like this
Use in B1 where you put the client name in A1
=INDEX(INDIRECT("'[sample file register
.xlsx]"&LEFT(A1,1)&"'!$A$2:$A$20"),MATCH(A1,INDIRECT("'[sample file
register .xlsx]"&LEFT(A1,1)&"'!$B$2:$B$20"),0))
Regards,
Sam Mathai Chacko
On Sat, Jun 9, 2012 at 5:06 PM,
Dear All,
Please find enclosed herewith the sample file.
Thanks
CA Vivek Jain.
On Friday, 8 June 2012 10:12:45 UTC+5:30, Vivek wrote:
> I have created a file index , with separate sheets alphabetically.
>
>
>
> Now I want to use the vlookup function in a new file, wherein I would type
> the
