Printable View
There is something strange about this lookup.
The lookup table was copied in from another workbook using a macro.
There is some formatting problem with cell A2. If you type 3001 in again over the old number it works.
Does anyone know what the problem might be?
I worked it out.
If I right click on cell A2 and press Format Cells it wrongly tells me that the format is a number. It's actually stored as text. Cell A3 is stored as a number.
However I do want the numbers to be stored as text so I've had to rework some code to make sure that the lookup numbers are also being written to the sheet as text.