I have a simple VLOOKUP(A2,Source.xls!production,5,FALSE) in the 'Original'
sheet
and everything is fine except some values. It gives #N/A. But, it's there in
the Source sheet.
The looking values are as A2 = SOS, A3 = STF, 6OC, etc.
When I go to the Sheet1 for the cells with #N/A and copy and paste the value
into the Original sheet I can get rid of all #N/A where it's only text as
STF, etc. But, for the cells where there is the first one is number such as
6OC or 2TT it continues to give me #N/A despite copying and pasting or even
substituting ref with the exact value as
VLOOKUP("2TT",Source.xls!production,5,FALSE).

Could anybody advise anything regarding this phenomenon?

Thanks