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...
also you say "if I remove the first IF/OR part of the formula it works beautifully," so i would check the value(s) for L5. Maybe confirm the output of the following:
=IF(OR($L5="Vacant",$L5="Unfunded",$L5="Intern"),$L5,"testing")
=IF(ISNA(VLOOKUP($M5,ActiveFTE[Employee ID],1,FALSE)),"Term","Yes")
based on your comment it sounds like you should get "testing" from the 1st and "Term" or "Yes" from the 2nd?
Assuming you have a whole column with this formula do you get #N/A for all the lines or only some?
thanks for the suggestion....
this morning i took the if/or part of the formula and put it on the end and it behaved like it did before - dunno why, but i'm just happy it worked😃