Thread: lookup formula in a Table given row and column

I need a formula to return a value in a chart based on matching the headings. I am sure something simple is out there.

Please see that attached:
I would like to add a formula in C2. I would like this formula to look at A2 and B2 and then return the value from the chart next to it.

for example: if A2= 1 Gallon and B2= 3 then the formula in C2 will give me "3"

thank you for your help

Hi sciartilli and welcome to the forum,

If you would, please click on the green Edit button below your original post and rename this thread to a more specific name like: "Lookup formula in a Table given row and column". Your thread title is a little too vague to find it again.

Then try this formula in C2 and pull it down.

=INDEX($G$2:$R$13,MATCH(A2,$F$2:$F$13,0),B2)

If you didn't have numbers in your column titles you would need another match function in the formula.

See the attached with a little more complicated formula.