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)

"scolbert" wrote in message
...
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!