LOOKUP problem
 

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


--
pdgaustintexas
------------------------------------------------------------------------
pdgaustintexas's Profile: http://www.excelforum.com/member.php...o&userid=30600
View this thread: http://www.excelforum.com/showthread...hreadid=502697

LOOKUP problem
 

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"
<pdgaustintexas.21upiz_1137622503.7955@excelforu m-nospam.com wrote in
message news:pdgaustintexas.21upiz_1137622503.7955@excelfo rum-nospam.com...

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


--
pdgaustintexas
------------------------------------------------------------------------
pdgaustintexas's Profile:
http://www.excelforum.com/member.php...o&userid=30600
View this thread: http://www.excelforum.com/showthread...hreadid=502697

LOOKUP problem
 

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