Forum Discussion
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 A...
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))