How to use a different words to equal other words

I have a cell A1 with the word APPLE
Cell A2 has the word ORANGE
Cell A3 has the word BANANA

I want in column B a formula to look at the word in column A and put the proper name beside it from a range of words I've selected.

From a formula in column B using "if", if it see's the word APPLE, then it should put RED DELICIOUS in column B1. If it sees the word ORANGE like in A2, then it would put the word LARGE ORGANIC. If it see's the word BANANA in column A, then it would use the word YELLOW FRUIT in column B.

After the formula has been pasted in column B, then it would look like
B1: RED DELICIOUS
B2: LARGE ORGANIC
B3: YELLOW FRUIT

I was assuming a simple "IF" formula, but I'm not to sure how.

Any advice would be appreciated.

What if I want to put the table for column D and E in a different worksheet...do I have to do something different?

Ok. Think I figured it out the other worksheet...but I think there is something missing from your formula...

=VLOOKUP(A1,$D$1:$E$3,2,0)
for different worksheet...
=VLOOKUP(A1,Worksheet!$D$1:$E$3,2,0) Is that all I have to do, where Worksheet is the name of the worksheet followed by !

But if A1 looks inside D1:3...how does that work as I only see $D$1: and then to $E...so is it only looking in D1 then? Would I not need $D$1:$D$3 or something?

I might as well shoot straight with this one...

I put my values in B136:143 and their match in C136:143 in a sheet called "Configurator"

Looking forward to your help :-)

Nevermind. I got it!

=VLOOKUP(A1,Configurator!$B$136:$C$143,2,0)

Thanks! Solved!

One more addition to the question.

What if I put a table where fruits are in E1:E3 & the proper name in D1:D3 (backward of what was before)

I tried changing the code to read $E$1$D3,2,0 but it always switches it back to D$1:$E$3