John
I don't see any obvous problem with your formula. To troubleshoot those kinds
of problems in messy formulas they can be calculated in parts. A lot of people
don't know this, but you can highlight on the formula bar, only one of your
nested functions or a rangename, then hit F9 and it will calculate only the
highlighted part of your formula. For example, higlight
match(d9,employeenames, 0), then hit F9 and see if you get a result or an
error. Use that method to systematically rule out each part of your formula.
Once you find out which embedded function is causing the error the problem will
be obvious to you, maybe.
Good luck.

Ken
Norfolk, Va