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