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
