Forum Discussion

Copper Contributor

Dec 08, 2021

Drop down list inside if statement

Good morning everyone, Iam trying to create sth like a guide on whether or not an employee is eligible to receive end of service award based on certain selections. File is attached. I want C9...

EOS.xlsx14 KB

excel

Formulas and Functions

Yea_So

Bronze Contributor

Dec 28, 2021

Ghostgirl

as a variant

EOS.xlsx15 KB

bosinander

Iron Contributor

Dec 29, 2021

Yea_So Compared to

=IF(C7="termination";G3#;I3#)

your variant

=IF(Sheet1!C7="Termination";Sheet2!$A$1:$A$2;"")

works with older versions of Excel not supporting spill areas (#) and also moves the list items to a separate configuration sheet. I think it is a good setup, using a separate sheet for setup variables.