Forum Discussion

Englishable's avatar
Englishable
Copper Contributor
Nov 04, 2025

Match value in cells, perform formula

I have a spreadsheet with a list of items and their costs. I have another section with a list of retailers and a hypothetical discount.

 

How could I write a formula that matches the value in A2 with Column F and then multiplies the value in C2 by corresponding value in Column G? In this example, I would want to find the value of A2 (Kohl's) in column F, and then multiply the cost of the shirt, C2, by the discount % Kohl's offers, G4. I don't want to have to do multiple manual formulas of = C2 * G4, it's a big spreadsheet.

 

Formulas and Functions

1 Reply

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Nov 05, 2025

    try this:

    =C2:C7*(1-XLOOKUP(A2:A7,F2:F7,G2:G7,0))

    if you don't have 365 then 

    =C2*(1-IFERROR(VLOOKUP(A2,$F$2:$G$7,2,0),0))

     

Resources