Forum Discussion
jmammen
May 22, 2023Copper Contributor
Need help on a complex excel formula
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"
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)