Returning a value based on sub columns

[RaviP23]

Hi,

I have one table with two different variables, the second variable is split into 4 sub columns

I have two data validation cells that I have set up to look at the first column and then the sub columns

What formula would I use to return a number from the table based on those two variables?

[#2 · Accepted solution]

@RaviP23 

=INDEX(Number_Range, MATCH(Pond_Site_Value, Pond_Site_Range, 0), MATCH(HSG_Value, HSG_Range, 0))

[#3]

@Hans Vogelaar 

Thank you so much! that worked