I'm using the IF statement to fill in a value from a cloum. but I think I'm
hitting the limit of the IF statement.

bases on a value in cell F20 copy coresponding vale. Now I need more IF
statemnents, is there a better way ?

Tks

Roger






"=+IF($F$20=1,(AQ23),IF($F$20=2,(AU23),IF($F$20=3, (AX23),IF($F$20=4,(BN23),IF($F$20=5,(BQ23),IF($F$2 0=6,(BT23),IF($F$20=7,(AQ23))))))))"