Multiple If/Or Statements

[scolbert]

Need a formula to evaulate (If CellA = 1, Then enter value in CellD), OR (If
CellA = 2, Then enter value in CellE), OR (If CellA = 3, Then enter value in
CellF). Any/all assistance is greatly appreciated!

 

[Bob Phillips]

If just those conditions then

=IF(A2=1,D2,IF(A2=2,E2,IF(A2=3,F2,"")))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[JE McGimpsey]

One way:

=INDEX(D1:F1,A1)

 

[scolbert]

Got it - trying to make it more difficult than it was - thanks!