I believe your description is wrong.
If the *first* row contains names, Hlookup will *not* lookup values in the
second row, and return names from the first row.

Assuming that was a typo, and values are in AP87 to BV87,
With names in AP88 to BV88, try this *array* formula:

=INDEX($AP$88:$BV$88,LARGE(IF($AP$87:$BV$87=CD88,C OLUMN($A:$AG),""),COUNTIF(CD88:$CD$120,CD88)))

--
Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of
the regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually. Also, you must use CSE when
revising the formula.

*After* the CSE entry, copy down as needed.


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"J" wrote in message
...
I have a 33 column, 2 row array. The first row contains names. The second
row
contains values between 0-20. I use HLookup to find a name that matches a
number and return the name. I do this down another column of 33 fields so
it
lists every name. The problem is if HLookup finds a value, it will return
the
same name multiple times (depending on how often the value appears)

Example:
CD88 - 6
CD89 - 6
CD90 - 5

=HLOOKUP(CD88,$AP$87:$BV$88,2,FALSE)

For instance, Person A and Person B both have values of 6, Person C has a
value of 5. When my HLookup function gets to CD88, it returns person A.
The
second row Hlookup looks now for CD89 (which is also 6). Instead of
returning
Person B, it returns Person A again.

How can I set up my function to skip over names it has already selected so
I
get all 33 unique names.

Thanks,