| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding a value based on contents of two cells
My list has 3 columns:
Column A Column B Column C County State Office Hall GA XYZ Office Fulton GA ABC Office Cuyahoga OH DEF Office Etc, for about 500 rows. I need to find the office that handles the county/state combo listed in Column C. Some county names are replicated in other states, so I need the one for the specific state. The reference cells a County will be in cell G1, and State in H1. These values are the result of a vlookup on another sheet. How do I do this, please? Either a VBA or the formula would be great. Thanks in advance. Robert |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting cells based on conditional formatting | Excel Discussion (Misc queries) | |||
| Macro to highlight cells based on content | Excel Worksheet Functions | |||
| how do i add in numbers automatically based on adjacent cells cont | Excel Discussion (Misc queries) | |||
| Automatically filling in cells based on another cell's content | Excel Worksheet Functions | |||
| Excel should have the option to merge contents when merging cells. | Excel Discussion (Misc queries) | |||
Threaded Mode
