Index / Match / Lookup / VLookup / ??? Need Help

I am trying to lookup pairs of months in a table, then depending on what month pairs a user types in it will return the value from the table under the month pair in the table.

See Attached Picture.
The blue arrows represent where I want the values to go.

For example,
The user enters "feb" in A7 and "may" in A8. I want th then look through all the month pairs in the table above (B2:E3). It then recoginizes that B2&B3 Match, so it inputs 1.23 in cell B8.

Your help is greatly appreciated.

Try the following array formula...

B8, copied to B11 and B14:

=INDEX($B$4:$E$4,MATCH(1,($B$2:$E$2=$A7)*($B$3:$E$3=$A8),0))

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Originally Posted by sslack

I am trying to lookup pairs of months in a table, then depending on what month pairs a user types in it will return the value from the table under the month pair in the table.

See Attached Picture.
The blue arrows represent where I want the values to go.

For example,
The user enters "feb" in A7 and "may" in A8. I want th then look through all the month pairs in the table above (B2:E3). It then recoginizes that B2&B3 Match, so it inputs 1.23 in cell B8.

Your help is greatly appreciated.

Thank you so much. That worked great!!