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.
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.
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
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.
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.