| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you use sumproduct to return specific cell data?
I have the following scenario:
A B C D E 1Hotel# 1Job# 2Hotel# 2Job# Staff# 101 6001 100 5002 231356 103 5002 101 6001 253586 406 2025 503 2025 365412 503 2025 601 6004 894561 The data from col A & B are connected by row ... meaning 101 & 6001 go together and should not be worked individually (thus the number 1 in the col headers connect those two cols, and the number 2 in the col headers connect those two columns C and D). I want to find a way for the formula to take the data that is in the same row in col A/B, in this case 101/6001, and find a match anywhere in col C/D, and return to me the data in col E that is in the same row as the match. So, for instance, row 1, I have 101 and 6001. I look down col C/D and find a match 101 and 6001 in the second row. So, the returned data would be 253586 because it is in the same row as the match found in C/D. Sorry, for the long way about this. I thought I could use sumproduct. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct - formula to return data OTHER than given criteria | Excel Worksheet Functions | |||
| Search for a number in a table and return data of a specific cell | Excel Discussion (Misc queries) | |||
| How to return the row # of an expression in specific array of cell | Excel Worksheet Functions | |||
| search multiple sheets for specific date, return data in cell to r | Excel Discussion (Misc queries) | |||
| Select cell containing specific text &return value from another ce | Excel Worksheet Functions | |||
Threaded Mode
