Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Returning a value based on sub columns

Copper Contributor

Hi,

 

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

 

RaviP23_0-1696342826638.png

 

 

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

 

RaviP23_1-1696342870398.pngRaviP23_2-1696342887856.png

 

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

 

 

2 Replies
best response confirmed by RaviP23 (Copper Contributor)
Solution

@RaviP23 

 

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

@Hans Vogelaar 

 

Thank you so much! that worked

 

 

1 best response

Accepted Solutions
best response confirmed by RaviP23 (Copper Contributor)
Solution

@RaviP23 

 

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

View solution in original post