I'm trying to summarize the expanded table in the summary table. To this end, I'm trying to come up with a formula in column F under "Goods" to return the first matching cell's value (text) in column B whenever column A equals column E.
I've also added an outcome table to show what I expect.
Any solution?
| قبض انبار.xlsx | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | Expanded Table | Summary Table | |||||||
| 2 | |||||||||
| 3 | |||||||||
| 4 | Code | Goods | value | Code | Goods | value | |||
| 5 | 1 | backpack | 10 | 1 | 19 | ||||
| 6 | 1 | pen | 1 | 2 | 8 | ||||
| 7 | 1 | pencil | 1 | 3 | 18 | ||||
| 8 | 1 | eraser | 2 | 4 | 9 | ||||
| 9 | 1 | notebook | 5 | ||||||
| 10 | 2 | apple | 1 | ||||||
| 11 | 2 | orange | 1 | ||||||
| 12 | 2 | banana | 2 | ||||||
| 13 | 2 | pineapple | 3 | Outcome | |||||
| 14 | 2 | carrot | 1 | ||||||
| 15 | 3 | shirt | 6 | ||||||
| 16 | 3 | t-shirt | 5 | ||||||
| 17 | 3 | pants | 4 | Code | Goods | value | |||
| 18 | 3 | hat | 3 | 1 | bcakpack | 19 | |||
| 19 | 4 | water | 1 | 2 | apple | 8 | |||
| 20 | 4 | lemon juice | 2 | 3 | shirt | 18 | |||
| 21 | 4 | tea | 3 | 4 | water | 9 | |||
| 22 | 4 | coffee | 3 | ||||||
Sheet1 | |||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| G5:G8 | G5 | =SUMIF($A$5:$A$22, E5, $C$5:$C$22) |
I've also added an outcome table to show what I expect.
Any solution?
