Return one value based on the result of another

[slaughtontdc]

Hi

Say I have a dropdown list in cell A1 which has ITEM 1, ITEM 2, ITEM 3 for the users to choose from.

Say in B2 I want the content to be decided by what the user selects from the dropdown list in A1.

For example, if the user selects ITEM 1 from the A1 drop down list, I want B1 to say APPLE and if they select ITEM 2 I want B1 to say ORANGE etc

What is the correct statement to put in B2? I would have thought it would be something like:

IF (A1 = ITEM 1, B2 = APPLE) - excuse the simpleton approach!

Thanks