Need help on a complex excel formula

Copper Contributor

kindly help to wrirte a excel fromula for below.


Calculating monthly spend 


if Sheet 1 column "H" & sheet 2 column "H" matches  multiply the values of sheet 1 column "I"  and sheet 2 column "I" and bring the value to Sheet 3 Colum "I"

2 Replies
best response confirmed by Hans Vogelaar (MVP)

@jmammen There are multiple way to solve this. One way is to use XLOOKUP(). Try-





Thank you