Vlookup Change in Reference Cell
 

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

Vlookup Change in Reference Cell
 

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

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

--
Jacob


"Lai" wrote:

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