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.