G
Guest
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
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