Forum Discussion
Vlookup
I have created a Vlookup formula - VLOOKUP(A5,ETB!$A$9:$L$105,12), which returns the correct value, but when I copy it down it correctly becomes VLOOKUP(A6,ETB!$A$9:$L$105,12), but then returns the same value as the first formula. Please help - I've been messing with it for ages, but can't find where I'm going wrong!
Thanks
Fiona
13 Replies
Try changing the false to true. I always leave it omitted and just add an extra comma at the end, but when I forget the extra comma, I always have those type of issues. VLOOKUP(A5,ETB!$A$9:$L$105,12,)
Thanks so much for this - true just returns the same value as before and a comma gives me #N/A again.
I can't help thinking its something really basic that I'm missing, but I'm tearing my hair out trying to think of more things to try!
The #N/A suggests that your lookup value (A6) does not exist in the source data (ETB!A9:A105). Ensure that your lookup value exists in the list (the exact same value).
As a note Jakal_Moon, I have found it as a safe practice to always include "FALSE" as the [range_lookup] to ensure that VLOOKUP() returns the exact result that I am looking for (and otherwise an error if the lookup value does not exist).
- Thanks for this. I tried it but unfortunately it has returned #N/A. Not sure if I'm being daft but is my range_lookup not the ETB!$A$9:$L$105 part of my formula?
Please ensure calculations are set to automatic. Formulas menu | Calculation | Calculation Options | Automatic.
- Thanks, Patrick, yes it is, and all other formulae on sheet are behaving perfectly!
