How to do this VLOOKUP OR FORMULA.

[Learning Excel]

In A1 a number is enter : let's say 1 to 120.
Results in B1 will be :
if A1 = 1,2,3,11,12,13,21,23 OR 25 then B1 will show GRAPE
if A1 = 4,5,6,7,8,9,10 OR... then B1 will show LEMON
Etcetera.
Could somebody help me to figure it out?
This is just an example. There numbers with 4 digits and they
do not have any pattern or consecutivity, but there are 12 fruit
that I need to appear in B1 depending on the numbers in A1.
THANKS.

 

[T. Valko]

There numbers ... and they do not have any pattern or consecutivity

Use VLOOKUP

See this:

http://contextures.com/xlFunctions02.html

 

[Brad]

Vlookup can solve this problem

Example
In d1 = have the number 1
d2 = have the number 4
e1 = grape
e2 = lemon

=vlookup(a1,d1:e2,2,false)

adjust the range d1:e2 to suit the your needs.

the false is needed to make sure that you have an exact match....

 

[Learning Excel]

Thanks Brad and T. Valko for the lesson.
Interesting website T.
Well put Brad.

 

[Brad]

You're welcome.
--
Wag more, bark less

Thanks Brad and T. Valko for the lesson.
Interesting website T.
Well put Brad.