yogi_ Multi Creiteria Lookup Involving Rows And Columns

Google Spreadsheet   Post  #2526

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Oct-26-2018

question by: K. Young
https://productforums.google.com/forum/#!topic/docs/0CWUz2d_ypA;context-place=forum/docs

Lookup IF function across rows and columns- is this possible?

I need a formula that will find data from a sheet based on 3 different factors. Those factors are on rows and columns. There isn't a way to get them all in columns or rows- they have to stay where they are. 

I'm not sure if a query can do this or an array function, but the lookups are working because they can only do vertical or horizontal. not sure the best way to approach and would love some input. 

Example Doc: 

Formula in Cell D2 performs a lookup on sheet "Ranges" with the following contingencies:

(if(Ranges!A:A=C2,if(Ranges!1:1=B2,if(Ranges!2:2="50th")))

Current says "NA" because I don't have the right formula. Should return "85"

https://docs.google.com/spreadsheets/d/1ejwxdCOPJkNfItvqq1vY7k_fViqOhhOlpA61hNoY3zc/edit?usp=sharing