Forum Discussion
Need help with a nested IF w/ISNA vlookup formula
If indeed it's the case that "the ONLY thing that has changed from the last file and this file is the list of active employees" then the problem isn't that the formula isn't working; it's something about or in that new list of active employees. That error means data is not available. (When one of my spreadsheets returns that error, when looking for things in a newly downloaded data file, I can always trace it back to some kind of change in the data itself.)
I would suggest leaving the formula alone and taking a close look at the data.
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😃
