You say the thing you want to look up is in D1. Your formula is looking up
G1. If you want the result to be in G1, you put the formula there and lookup
D1 as in:
=VLOOKUP(D1,REPORTS!$B$94:$C$106,2,FALSE)

"KeK23" wrote in message
...
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.