Formula to find two criteria from a table and return corresponding result

Hi!
I would like to use the attached data (rating and appetite levels) to look at the "tolerance table" and return a result from the table.

Examples given manually in the spreadsheet - so a rating of 9, with an appetite of 4 will give a tolerance level of "leaning high". Imagine I could play around and come up with maybe an IF formula to put into column G, but I really need it to read out of the "tolerance table" and not sure I can do that with an IF formula?

I intend to send this on to someone and I'd like them to be able to update the table and the results change accordingly.

Any thoughts?

Thanks!

Hi emma390,

Try this in G2 and copy down:

=INDEX($J$4:$N$8,MATCH($E2,{1,4,6,10,15},1),MATCH($F2,$J$3:$N$3,0))

Blessing

hi,

see in attachment if it work for you.

Thanks
Rohit

Thank you both! They both worked a treat

Cheers