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