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)

Forum Discussion

jmammen

Copper Contributor

May 22, 2023

Solved

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"

Test.xlsx20 KB

excel

Formulas and Functions

Harun24HR
May 22, 2023
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)
Test.xlsx21 KB

2 Replies

Harun24HR
Bronze Contributor
May 22, 2023
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)

Test.xlsx21 KB
- jmammen
  Copper Contributor
  May 22, 2023
  Thank you