Forum Discussion
Vlookup
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).
No, it really does - they all do - I just pasted col A from the first sheet onto the ETB one. But even if I put the absolute value in the formula it still picks up the value on the first row.
- Would you mind sending a sample file showing this error? (Please of course remove any sensitive information)
