VLookup Help on true/false results and test

  • Thread starter Thread starter Lou
  • Start date Start date
L

Lou

Good day everyone.

On my VLookup listed below, what would I use as a final
statement so it will not to return duplicate results from
columns of names being compared. I tried adding ,FALSE but
then everything goes #N/A, adding TRUE gives me duplicates.
Any help would be great.

=VLOOKUP(E11,$A$1:$D$314,1)

Thank you.
Lou
 
Lou said:
Good day everyone.

On my VLookup listed below, what would I use as a final
statement so it will not to return duplicate results from
columns of names being compared. I tried adding ,FALSE but
then everything goes #N/A, adding TRUE gives me duplicates.
Any help would be great.

=VLOOKUP(E11,$A$1:$D$314,1)

Thank you.
Lou
Click to expand...

I don't understand what you are asking.

The formula you quote will look up E11 in the first column of $A$1:$D$314
(i.e. $A$1:$A$314) and return the first match from column 1 of that range
(i.e. $A$1:$A$314 again!). Adding a fourth argument will only affect whether
it looks for an exact match (FALSE) or an approximate one (TRUE), but the
latter requires that the lookup range is sorted in ascending order.

What do you mean by "gives me duplicates"?
 
Paul Thank you.

Duplicates, If it did not find an exact match it would
bring in a similar result. I think the descending order
might have been the culprit there. I am going to try.

Thank you.
 
Back
Top