CODEWITHSUNDEEP
google-sheets
mark0018
mark0018

Reputation: 25

Vlookup using multiple conditions [Vlookup & Hlookup combined]

I want to populate my review sheet using the raw data sheet.

Daily data is appended in the raw data sheet. I think a combination of vlookup & hlookup is requried but not sure how to procees on this.

Review sheet enter image description here

Raw sales sheet enter image description here

Link to the sample sheet

Upvotes: 0

Views: 119

Answers (1)

Sherin Jayanand
Sherin Jayanand

Reputation: 204

You can use the below formula in'B2 of the Review sheet:-

=SUMIFS(Raw!$C:$C,Raw!$A:$A,Review!B$1,Raw!$B:$B,Review!$A2)

Then either drag the formula or do a copy-paste to other cells.

Hope that works.

Upvotes: 1

Related Questions