Forum Discussion

gavin240's avatar
gavin240
Copper Contributor
Jun 22, 2022

repeating IFS formula on different data sets in false

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

 

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    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.

Resources