You can use Indirect Function for the same... VLOOKUP(H17,indirect(SC231WK34.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 > -- Regards Rajan verma +91 9158998701 -- ---------------------------------------------------------------------------------- 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
