Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do this VLOOKUP OR FORMULA.
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. |
#2
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do this VLOOKUP OR FORMULA.
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.... -- Wag more, bark less "Learning Excel" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do this VLOOKUP OR FORMULA.
Thanks Brad and T. Valko for the lesson.
Interesting website T. Well put Brad. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "Brad" wrote: 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.... -- Wag more, bark less "Learning Excel" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to do this VLOOKUP OR FORMULA.
You're welcome.
-- Wag more, bark less "Learning Excel" wrote: Thanks Brad and T. Valko for the lesson. Interesting website T. Well put Brad. -- Socrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. "Brad" wrote: 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.... -- Wag more, bark less "Learning Excel" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Alternative formula to the vlookup formula? | Excel Worksheet Functions | |||
convert vlookup formula to link formula | Excel Worksheet Functions | |||
Using VLOOKUP formula | Excel Discussion (Misc queries) | |||
Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
how to use vlookup formula | Excel Worksheet Functions |