| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search value in 2 columns return value in another
2 worksheets
Sheet 1 Area Sector Year Berkley Retail (BLANK) Berkley Office (BLANK) Clawson Retail (BLANK) Clawson Office (BLANK) Sheet 2 Area Sector Year Berkley Retail 1 Clawson Retail 4 Clawson Office 3 Berkley Office 2 How do I get the Year value in sheet 2 to populate into sheet 1 based on 2 matched criteria? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for value on another sheet, return Y/N | Excel Discussion (Misc queries) | |||
| Search table for string return next columns value | Excel Worksheet Functions | |||
| Search and return | Excel Worksheet Functions | |||
| Search Multiple columns for criterion asterisk (*) and Return Numeric Label | Excel Worksheet Functions | |||
| search for and return more than one row in a sheet | Excel Worksheet Functions | |||
Threaded Mode
