Vlookup to extract data while matching the field

[faisus]

Hello people. Hope all doing well.

I am trying to fill Sheet 2 from Sheet 1, however my formula seems incorrect. Under Sheet 2 the branch B2 column has data validation since there are many branches, so whoever selects any branch, then the data would populate as per the branch.

Kindly advise.

Thanks.

 

[johnny51981]

Since these are values, rather than texts, you might be better served by using a SUMIFS function.

Corporate: =SUMIFS(Sheet1!$C:$C,Sheet1!$A:$A,Sheet2!$B$2,Sheet1!$B:$B,$A7)

Then for the other categories (SME, Individual, etc), just redirect at Sheet1!$C:$C to the appropriate column.

 

[faisus]

go it thank you..