Forum Discussion
Solved
Extract value from row that fulfills multiple criteria
Dear experts I would like to extract a specific value from a cell based on multiple criteria that need to be true in the same row. Simplified example based on screenshot below: Goal: Extract...
You have a few options depending on if you expect multiple rows to contain Spain/Shutters/1972
If expecting 1 row to have that combination, XLOOKUP:
=XLOOKUP(G2&G3&G4,Table1[Country]&Table1[Product Type]&Table1[Year],Table1[Incremental Sales])If expecting multiple entries, SUMIFS:
=SUMIFS(Table1[Incremental Sales],Table1[Country],G2,Table1[Product Type],G3,Table1[Year],G4)
You have a few options depending on if you expect multiple rows to contain Spain/Shutters/1972
If expecting 1 row to have that combination, XLOOKUP:
=XLOOKUP(G2&G3&G4,Table1[Country]&Table1[Product Type]&Table1[Year],Table1[Incremental Sales])If expecting multiple entries, SUMIFS:
=SUMIFS(Table1[Incremental Sales],Table1[Country],G2,Table1[Product Type],G3,Table1[Year],G4)
Patrick2788 - awesome thank you 🙂 that worked exactly how I wanted it!
- You are welcome!
