LOOKUP FUNCTIONS

[SUSIE]

I need help with the lookup function. I can't use vlookup
because there are possible duplicates in which case it
returns an n/a response.

So I'm using a lookup function that works great except
that it will give me a closest match if there is none. Is
there any way to put something in there that will give me
a "not found" response instead of closest match?

Please help

 

[Norman Harker]

Hi Susie!

First look at the problem "manually"

You say that there are duplicate entry possibilities. What criteria
would you use to decide which should apply?

Assume I have a simple lookup table:

John 15
Mary 20
Fred 30
John 25
Bill 30

If I am looking up "John" what criteria do I use to decide whether or
not I extract 15 or 25?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Public Holidays Monday: Antigua and Barbuda, Bahamas, Barbados,
Belize, Dominica, Grenada, Guyana, Jamaica, Montserrat, St. Kitts and
Nevis, Saint Lucia, St. Vincent and the Grenadines, Trinidad and
Tobago, Turks and Caicos Islands (All Caricom Day); Bangladesh (Bank
Holiday); Cayman Islands (Constitution Day); Solomon Islands
(Independence Day); Spain (Running of the Bulls); Tanzania (Saba
Saba); Zambia (Heroes Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.