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 vivek.j...@gmail.com wrote:
How to use the Vlookup function in a separate excel file, to search
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 want
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
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, Vivek
Please see attached
2012/6/9 Vivek vivek.j...@gmail.com:
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
Please replace previous
Please see attached
2012/6/9 ChilExcel chilexcel...@gmail.com:
Please see attached
2012/6/9 Vivek vivek.j...@gmail.com:
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