repeating IFS formula on different data sets in false

Occasional Visitor

Hi, my spread sheet is 5 columns by 30,000 of raw data.

I am using the IFS function in column 6. If my IFS function remains false using data from cell A1 and cells A2 to A5, I want to repeat the same function using date from cell A1 and data from B2 to B5, if it still remains false I want to repeat the same function using date from cell A1 and data from c2 to c5, etc until the IFS function is true. 

 

Is there an easy way to tell excel to "repeat" the same IFS statement using a different data set without making an incredibly long IFS or having a very high number of IF/IFS?

 

I will then be redoing the whole exercise with B1 and B2 to B5 data, then C1 and C2-C5 data, etc.

 

many thanks in advanced

 

1 Reply
This is very do-able with a LAMBDA (If you're on 365). If you're able to upload a sample workbook, you'll likely get a few excellent solutions to pick from.