or how about this instead?

=INDEX(F3:I20,MATCH(I50,I3:I20,0),1)

--


Gary


"Tom Ogilvy" wrote in message
...
if there is only one occurance of I50 in the range I3:I20, then they would be
equivalent.

I don't have an opinion on which is preferred

--
Regards,
Tom Ogilvy


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
are these 2 equivalent and if so, which is preferred? there are a few hundred
of these formulas in a workbook and i'd like to change the 2nd one to the
first one.

=T50/SUMIF($I$3:$I$20,I50,$F$3:$F$20)
=T50/(LOOKUP(I50,$I$3:$I$20,$F$3:$F$20))



--


Gary