Forum Discussion
Need help with a nested IF w/ISNA vlookup formula
A formula that I have been using for nearly 4 years has decided to stop working and I don't know how to fix it. Everything I have tried fails miserably. The formula is this: =IF(OR($L5="Vacant",$L...
Hi bema2001 !
Try this formula:
=IF(OR($L5={"Vacant","Unfunded","Intern"}),$L5,
IF(COUNTIF(ActiveFTE[Employee ID],$M5),"Yes","Term"))You can shorten the formula with IFS like this:
=IFS(OR($L5={"Vacant","Unfunded","Intern"}),$L5,
COUNTIF(ActiveFTE[Employee ID],$M5),"Yes",1,"Term")Or using SWITCH like this:
=SWITCH(1,--OR($L5={"Vacant","Unfunded","Intern"}),$L5,
COUNTIF(ActiveFTE[Employee ID],$M5),"Yes","Term")You need to check the L5 value. If there's an error, the formula will also display an error. You can wrap this formula in an IFERROR function and assign a value to indicate when this occurs. Blessings!