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 "...
excel
Formulas and Functions
  • Harun24HR's avatar
    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)

     

     

Harun24HR's avatar
Harun24HR
Bronze Contributor

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)

 

 

jmammen's avatar
jmammen
Copper Contributor
May 22, 2023
Thank you

Resources