One way:

=INDEX(D1:F1,A1)

In article ,
scolbert wrote:

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!