V LOOKUP

[twins160]

Hi, I've been trying to find a solution to this all day. Any help to get me
past this would be much appreciated.

Using VLOOKUP, I have a car license plate e.g. AB51 DVL.
On a separate worksheet I have a table with the CODE (51 etc) in one column
and the DATE (e.g. Sept 2001) in the next. I need to create a VLOOKUP so that
when a licence plate is entered, the date that corresponds to the code in
that licence plate is displayed in the correct cell. When I type in the "51"
in the VLOOKUP I get the correct answer, but when I type the cell (e.g.A3)
where the licence plate is I get #N/A. I have tried to use MID function, for
example =MID(A3,3,2) which extracts the number from the licence plate into
another cell and have used that cell as reference, but I still get the #N/A.
Any help would be much appreciated. Thanks in advance.

 

[twins160]

Thank you all ever so much, I knew I was missing something out. It works
perfectly now with the =--MID(A3,3,2) .

 

[David Biddulph]

Glad it helped.
--
David Biddulph

Thank you all ever so much, I knew I was missing something out. It works
perfectly now with the =--MID(A3,3,2) .