Pete,

thanks fopr your help, have changed the formula but still returning an #N/A
answer any ideas.

Keiran

"Pete_UK" wrote:

If your second sentence is correct, then you want the formula in G1
and you want the lookup_value to be in D1, so shouldn't it be:

=VLOOKUP(D1,REPORTS!$B$94:$C$106,2,FALSE)

Hope this helps.

Pete

On Oct 3, 11:11 pm, 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(G1,REPORTS!$B$94:$C$106,2,FALSE) and keep
getting false.

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

Any ideas would be greatly appreciated.