He is Considering #N/A Error.. On Thu, May 5, 2011 at 7:38 PM, <pravin.si...@gmail.com> wrote:
> My friend I'll have data for all 34 35-53 soi there will be no error > > Sent on my BlackBerry® from Vodafone > ------------------------------ > *From: * NOORAIN ANSARI <noorain.ans...@gmail.com> > *Date: *Thu, 5 May 2011 18:04:26 +0530 > *To: *Pravin Kumar<pravin.si...@gmail.com>; <excel-macros@googlegroups.com > > > *Subject: *Re: $$Excel-Macros$$ > VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0) > > 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 > -- 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
