Need help on a complex excel formula

[jmammen]

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 · Accepted solution]

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

=XLOOKUP(H2,Sheet1!H:H,Sheet1!I:I)*XLOOKUP(H2,Sheet2!H:H,Sheet2!I:I)

[#3]

Thank you