VLOOKUP Won't Recognise Data Unless Manually Re-Typed

[Smok3y]

Hi there,

Having real trouble getting a simple VLOOKUP to recognise data - cells result in #N/A unless I manually retype the data which isn't practical.

I know there are issues between compatible data types in these functions, and have read similar threads about changing data through Text to Columns, but I cannot seem to get anything to work (every possibility I have done this step wrong though).

Can anyone step me through this? Seems like such a simple fix but it is doing my head in...

Cheers, Smok3y.

 

[arthurbr]

There is a good chance you have trailing spaces
Try wrapping your lookup value with the TRIM function = VLOOKUP(TRIM(a1),...
Or add wildcards to the lookup value = VLOOKUP("*"&a1&"*",