Posted to microsoft.public.excel.misc
|
|
How to do this VLOOKUP OR FORMULA.
There numbers ... and they do not have any pattern or consecutivity
Use VLOOKUP
See this:
http://contextures.com/xlFunctions02.html
--
Biff
Microsoft Excel MVP
"Learning Excel" wrote in message
...
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.
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.
|