=IF(ISERROR(VLOOKUP(B4,$E$3:$F$3,2,FALSE)),IF(ISERROR(VLOOKUP(B4,$H $3:$I$3,2,FALSE)),VLOOKUP(B4,$K$3:$L$3,2,FALSE),VLOOKUP(B4,$H$3:$I $3,2,FALSE)),VLOOKUP(B4,$E$3:$F$3,2,FALSE))
On Jan 25, 10:57 pm, Aamir Shahzad <aamirshahza...@gmail.com> wrote: > Hi experts, > > Can I find values in multiple sheets with vlookup function. sheet is > attached. iferror function can be use but it can helpful only with 2 sheet, > any guidance? > > Regards, > > Aamir Shahzad > > Lookup in different sheets.xlsx > 12KViewDownload -- ---------------------------------------------------------------------------------- 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