asked on

vlookup function assistance

Dear experts,

I'm stuck trying to create a vlookup function which is not returned desired results.

Could I get some assistance to determine why the function is not returning the values I am looking for. Please see attached and let me know if you have any question.

Thanks for your help!

lcha
VLOOKUP.xlsx

lcha

ASKER

=VLOOKUP(H4,$C$4:$D$13,COLUMN(D4),FALSE)

I am searching for the value in H4, searching table array $c$4:$D$13, column(d4) is the value I want to retrieve, and false to search for an exact match.

i tried changing the FALSE value to TRUE (to search for the closest match), but get the same results.

SOLUTION

ltsweb

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

lcha

ASKER

thank you so much for the quick reply.
this worked for the sample spreadsheet I provided you however for some reason in the real spreadsheet doesn't work.

The value I am looking for (65001328 - value in cell I4) is in the array (see formula below). Vlookup does a search for this value in column 1 of the array. It's there, but the formula is still returning #N/A

=VLOOKUP(I4,$E$2:$F$1029,2,FALSE)

Any insights into what may be causing this issue?

ASKER CERTIFIED SOLUTION

ltsweb

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Rob Henson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

lcha

ASKER

Thanks all for your feedback and help on this issue!

One of the columns was General format and the other was text.

to fix it, I highlighted the column i needed to change format, went to "data", "text to columns", selected delimited, tab, and the general format. This fixed the issue.