Why the quotes around the digit 1? Surely the 1 in J16 is numeric not text
I tried =IF(J16=1,LOOKUP((MIN(J4:J15)),J4:J15,$D$4:$D$15), "")
with some dummy data and it worked.

Also try
=INDEX($D$4:$D$15,MATCH(MIN(J4:J15),J4:J15,0))
OR
=IF(J16=1, ($D$4:$D$15,MATCH(MIN(J4:J15),J4:J15,0)) ,"")
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"pdgaustintexas"
<pdgaustintexas.229d2t_1138306253.4849@excelforu m-nospam.com wrote in
message news:pdgaustintexas.229d2t_1138306253.4849@excelfo rum-nospam.com...

I'm trying to identify the person with the lowest score in the column.
I'm using the formula

=IF(J16="1",LOOKUP((MIN(J4:J15)),J4:J15,$D$4:$D$15 ),"")

Column D represents the names
Column J represents their score
cell J16 indicates there was 1 low score

Sometimes I get the right name and sometimes I get #N/A.


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