Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Looking up information and returning a value
I have an Excel worksheet where I'm trying to display a value in a field
based on the state selected in another field. For example if the state is TX, the value is 100, if the State is FL, the value is 120 etc. I have the states listed on a worksheet in column A and the corresponding values in column B. Then I set up the second worksheet, same workbook with my other information. On this worksheet I want to select a state from a drop down (which I've done) and based on that selection populate the next cell (i.e. E1) with the appropriate value based on my look up table. How do I do this? Your help is much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
returning offset row from excel table | Excel Discussion (Misc queries) | |||
Returning a Value by Matching Two Columns of Data | Excel Worksheet Functions | |||
Vlookup returning Hyperlinks | Excel Worksheet Functions | |||
Returning multiple corresponding values using lookup in a list | Excel Discussion (Misc queries) | |||
Help comparing data and returning information... | Excel Worksheet Functions |