Using IF statement
 

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))))))))"

Using IF statement
 

Extend this

=INDEX(23:23,1,INDEX({43,47,50,66,69,72,43},MATCH( F20,{1,2,3,4,5,6,7},0)))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"shawnews" wrote in message
news:4dFui.44797$rX4.8939@pd7urf2no...
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))))))))"

Using IF statement
 

Why do you think you are hitting a limit in the if statement.

I see one problem, your last if (=7) has no false condition. you need to
add something like ",0" after "(AQ23)" If it is impossible for the value to
not be in the range of 1-7 then you can remove the last IF and just make
(AQ23) the return for a false on the =6 test.

There are probably better ways to do what you are trying to do but I can't
see a relation ship between the number in F20 and the column you are pulling
from. If they were evenly spaced you could calculate the column offset from
the value but that doesn't seem to be the case.

Hope this helps.

Peter Richardson

"shawnews" wrote:

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))))))))"