I want to lookup a value in a table, then return a value to a different
column based on the result.

For example:

Sheet 1 has:

col A
------
1
2
3
4

Sheet 2 (LOOKUP table) has:

col A col B
------ ------
1 Apple
2 Banana
3 Carrot
4 Date

I want to write a formula in sheet 1 that says:

if the value in col A is 1, enter Apple in col B
if the value in col A is 2, enter Banana in col C
if the value in col A is 3, enter Carrot in col D
if the value in col A is 4, enter Date in col E