Forum Discussion

Copper Contributor

Mar 08, 2020

Solved

A complicated IF

I have three columns Confidence levels (High, Medium, Low) Training Date Reassessment Date I would like this column to automatically show the date for the following High: add 90 days to trainin...

excel

Formulas and Functions

SergeiBaklan

Mar 08, 2020

sgtbrowne

As variant

=B1+IFNA(INDEX({30,60,90},MATCH(A1,{"Low","Medium","High"},0)),0)

SergeiBaklan

Diamond Contributor

Mar 08, 2020

sgtbrowne

As variant

=B1+IFNA(INDEX({30,60,90},MATCH(A1,{"Low","Medium","High"},0)),0)

sgtbrowne

Copper Contributor

Mar 08, 2020

SergeiBaklan Can I include this in a data validation? If so how?

SergeiBaklan
Diamond Contributor
Mar 08, 2020
sgtbrowne

I didn't catch about data validation, what is the purpose. Is that for Reassessment Date which entered manually?
- sgtbrowne
  Copper Contributor
  Mar 08, 2020
  I am using some data validation that allows certain dropdowns to already be present in each row of certain columns. I would like to be able to do the same thing with the formula. Right now, I would have to copy and paste the entry in each time and I would like to make this excel sheet as automated as possible.