Hi Pravin,
You could try using the INDIRECT function
VLOOKUP(H17,INDIRECT("[SC231WK"&A1&"34.xls]Sheet1!$I$5:$K$20"),H$15,0)
Change the A1 ref to the cell that holds the book number you want
Please note that I haven't tested this. I haven't tried VLOOKUP with INDIRECT
before.
Regards - Dave
Date: Thu, 5 May 2011 18:04:26 +0530
Subject: Re: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)
From: noorain.ans...@gmail.com
To: pravin.si...@gmail.com; excel-macros@googlegroups.com
Dear Pravin,
Please try it.................
=IFERROR(VLOOKUP(H17,[SCWK23134.xls]Sheet1!$I$5:$K$20,H$15,0),IFERROR(VLOOKUP(H17,[SC231WK35.xls]Sheet1!$I$5:$K$20,H$15,0),IFERROR(VLOOKUP(H17,[SC231WK36.xls]Sheet1!$I$5:$K$20,H$15,0),"")))
On Thu, May 5, 2011 at 12:47 PM, Pravin Kumar <pravin.si...@gmail.com> wrote:
Folk
I have different workbook with different name in different folder. the workbook
name will be like SC231WK34, SC231WK35, SC231WK36 etc. all the sheet will be in
the same format.
is there any way to write vlookup where I can link the part of the name to any
of cell.
VLOOKUP(H17,[SC231WK34.xls]Sheet1!$I$5:$K$20,H$15,0)
Thanks
Pravin
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Thanks & regards,
Noorain Ansari
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
