Forum Discussion
l3p3rkan
Apr 12, 2019Copper Contributor
What Formula do I use?
I am a car salesman with a spreadsheet that calculates how many units I have sold and my supergross (amount of money made on each vehicle I sell). I get paid based on a chart like this. What formula ...
Twifoo
Apr 12, 2019Silver Contributor
The formula in G3 of the attached file is:
=INDEX(B2:D6,
MATCH(G1,A2:A6,1),
MATCH(G2,B1:D1,1))