Vlookup Change in Reference Cell

[Lai]

Hi everyone,

I'm having trouble with my Vlookup formula

I'd initially had 1 column as my reference, changed the reference in another
column that is exactly the same as the 1st column (both are text as well) and
it does not work. I'm not sure why it is not working. Could the 1st column
be different somehow than the 2nd column eventhough they are visibly alike???

Thanks,
Lai

 

[Jacob Skaria]

Check for any spaces after the lookup value.. or try TRIM() the lookup value
as below

=VLOOKUP(trim(LOOKUP_VALUE),array,column_num,0)