200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I have to VLOOKUP from multiple sheets and I'm using the below formula, but somehow it's working just for some of the cells.
=IFERROR(VLOOKUP($B2,'Retika file 1'!$A$2:$B$3272,2,0),IFERROR(VLOOKUP($B2,'Retika file 2'!$A$2:$B$782,2,0),"Not found"))
Am I missing something?
Hello Roberta and welcome to the Forum.
Your nested (IFERROR(VLOOKUP formula looks okay to me, assuming you want to return a match from the range in sheet Retika file 1 or, failing a match there, a match from a shorther range in sheet Retika file 2 and, in the event of neither having matches, "Not found".
Suggest you check these things:
Look-up values can only be found in the look-up list if they match exactly. We don't know whether you are looking up strings, numbers or dates. Strings tend to have trailing or leading spaces to make them different. Number may actually have more digits than displayed. Dates may be fake or true dates and may be formatted differently. A few days ago I spent half an hour looking for a difference that turned out to be a space added to a string by the cell format.
Since your formula looks OK and works OK the duck rule should be applied which says that if it walks like a duck and quacks like a duck then it probably is a duck. Applied to your case, don't try to blame the formula.
