software

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: www.excelforum.com/member.php...oamp;userid=30600
View this thread: www.excelforum.com/showthread...hreadid=502697Just a guess, since I could not see the worksheet. If you are filling down
with your lookup formula and your quot;table_arrayquot; 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

quot;pdgaustintexasquot;
lt;pdgaustintexas.21upiz_1137622503.7955@excelforu m-nospam.comgt; wrote in
message newsdgaustintexas.21upiz_1137622503.7955@excelfo rum-nospam.com...
gt;
gt; I'm using a LOOKUP formula to determine who won a particular hole in a
gt; round of golf. Can anyone tell me why the LOOKUP formula only works on
gt; a few names?
gt;
gt; (See attached sample worksheet).
gt;
gt;
gt; --
gt; pdgaustintexas
gt; ------------------------------------------------------------------------
gt; pdgaustintexas's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30600
gt; View this thread: www.excelforum.com/showthread...hreadid=502697
gt;
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