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 s...
Hello Fiona11,
To find an exact match with the VLOOKUP() formula, use:
VLOOKUP(A6,ETB!$A$9:$L$105,12, FALSE)
If the [range_lookup] is omitted, VLOOKUP() will find the closest match in the first column.
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?