Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas?
If anyone can help me with this or try to point me in the right direction I
would be grateful. I am trying to type a specific number in one cell and then have text appear in the cell below. Example cell c8 I type 3113 and in cell c10 have Chicago, IL appear. Thing is I have about 200 different numbers representing different city's and states, so next time cell c8 might be 3001 and then need cell c10 read New York, NY. Any suggestions, thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas?
Using help research vlookup()
You will need to create at table This will get you what you want Just remember that the false in the equation below would be important =vlookup(c8,tablename,2,false) the false will make sure that you will have a match you may also want to use the following =if(isna(vlookup(c8,tablename,2,false)),"",vlookup (c8,tablename,2,false)) to make sure that if a number is selected - you won't get the nasty N/A showing up in the cell. Hope that helps... -- Wag more, bark less "YanksRock" wrote: If anyone can help me with this or try to point me in the right direction I would be grateful. I am trying to type a specific number in one cell and then have text appear in the cell below. Example cell c8 I type 3113 and in cell c10 have Chicago, IL appear. Thing is I have about 200 different numbers representing different city's and states, so next time cell c8 might be 3001 and then need cell c10 read New York, NY. Any suggestions, thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas?
hi
you need to put your numbers and cities in table off to the side then use VLookup in c10 to search the table and return the city based on what number you entered in c8. regards FSt1 "YanksRock" wrote: If anyone can help me with this or try to point me in the right direction I would be grateful. I am trying to type a specific number in one cell and then have text appear in the cell below. Example cell c8 I type 3113 and in cell c10 have Chicago, IL appear. Thing is I have about 200 different numbers representing different city's and states, so next time cell c8 might be 3001 and then need cell c10 read New York, NY. Any suggestions, thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |