LOOKUP problem

P

pdgaustintexas

I'm using a LOOKUP formula to determine who won a particular hole in a
round of golf. Can anyone tell me why the LOOKUP formula only works on
a few names?

(See attached sample worksheet).
 
L

L. Howard Kittle

Just a guess, since I could not see the worksheet. If you are filling down
with your lookup formula and your "table_array" is not set to absolute
referencing, that may be the cause.

A1:B25 should be $A$1:$B$25

And of course make sure the lookup values are identical, no spaces or Fred
Jones in one place and Fred E Jones in the other.

If still having problems you can send me an example workbook and I will
look at it.

HTH
Regards,
Howard

"pdgaustintexas"
 
V

vezerid

In addition to Howard's suggestion. LOOKUP() requires that the array is
sorted ascending. Is this the case?
Maybe you would prefer to use VLOOKUP(, , ,FALSE) instead?

HTH
Kostis Vezerides
 
Top