Need Formula Help

K

Kelly

Is there a function I could use to replace this monster:
IF(K9>0,IF(O9>=K9,L9,IF(O9>=I9,J9,IF(O9>=G9,H9,IF
(O9>=E9,F9,D9)))),IF(I9>0,IF(O9>=I9,J9,IF(O9>=G9,H9,IF
(O9>=E9,F9,D9))),IF(G9>0,IF(O9>=G9,H9,IF(O9>=E9,F9,D9)),IF
(E9>0,IF(O9>=E9,F9,D9),D9))))
I'm trying to say "look at order size and match up with
lot size and return price".
TIA
 
F

Frank Kabel

Hi
normally I would use VLOOKUP for this. But I'm still not sure how your
spreadsheet is designed. You may post some example data (e.g. data for
row 9), describe each cell and define your expected result. This would
be much easier to generate a formula for you :)
 
Top