Vlookup Change in Reference Cell

L

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
 
J

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top