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
