| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine cell value based on list from other sheet
Ok, I am trying to get cell f1 to fill in automatically based on the value of
G1. On another sheet I have a list of names in column A and corresponding codes in cloumn B. If the user inputs "denver" from a pull down menus in G1- I want it to find "Denver" on the list and display the code (that is in the cell next to denver on the other sheet) in Cell F1. Thanks for you help!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determine cell value based on list from other sheet
in F1
=if(G1="","",vlookup(G1,Sheet2!A:B,2,false)) -- Regards, Tom Ogilvy "TBAnashdk" wrote: Ok, I am trying to get cell f1 to fill in automatically based on the value of G1. On another sheet I have a list of names in column A and corresponding codes in cloumn B. If the user inputs "denver" from a pull down menus in G1- I want it to find "Denver" on the list and display the code (that is in the cell next to denver on the other sheet) in Cell F1. Thanks for you help!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Determine cell value based on list from other sheet
Perfect Tom- Thanks sooo much!!
Tom Ogilvy wrote: in F1 =if(G1="","",vlookup(G1,Sheet2!A:B,2,false)) Ok, I am trying to get cell f1 to fill in automatically based on the value of G1. On another sheet I have a list of names in column A and corresponding [quoted text clipped - 3 lines] Thanks for you help!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Determine next Saturday in calendar based on date in a cell | New Users to Excel | |||
| in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions | |||
| how to find and copy values on sheet 2, based on a list on sheet 1 | Excel Programming | |||
| List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions | |||
| I need to determine a cell range based on a blank cell | Excel Programming | |||
Linear Mode
