Forum Discussion

jmammen's avatar
jmammen
Copper Contributor
May 22, 2023

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)

     

     

Resources