I am trying to use a VLOOKUP formula but keep getting #N/A returned.

If in sheet 1 D1 abc123 (vehicle registration numbers) is entered then
populate G1 with Harry (Driver)

I have created a lookup table in a seperate worksheet (Reports) with a list
of vehicle registration numbers in column b and a list of drivers in column c

I am using this formula: =VLOOKUP(D1,REPORTS!$B$94:$C$106,2,FALSE) and keep getting a #N/A answer.


There are no spces in the registration numbers between numbers and text.
There are spaces between christian name and surname in C94:C106.

Any ideas would be greatly appreciated

On Oct 4, 11:10 am, KeK23 wrote:
I am trying to use a VLOOKUP formula but keep getting #N/A returned.



If in sheet 1 D1 abc123 (vehicle registration numbers) is entered then
populate G1 with Harry (Driver)

I have created a lookup table in a seperate worksheet (Reports) with a list
of vehicle registration numbers in column b and a list of drivers in column c

I am using this formula: =VLOOKUP(D1,REPORTS!$B$94:$C$106,2,FALSE) and keep getting a #N/A answer.

There are no spces in the registration numbers between numbers and text.
There are spaces between christian name and surname in C94:C106.

Any ideas would be greatly appreciated

When VLOOKUP returns #N/A it usually means it didn't find a perfect
match (because you're using FALSE in the statement).

Are you certain the value in D1 is in the table and is exactly the
same?

Try removing the FALSE from your VLOOKUP statement (just for testing).
What result does it return now?

The cells in column B (rego numbers) might need to be TRIMmed or
CLEANed to get a positive match??

Let us know...

cheers,
t.