Forum Discussion

RaviP23's avatar
RaviP23
Copper Contributor
Oct 03, 2023
Solved

Returning a value based on sub columns

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?

 

 

Resources