I will get an #NA error whenever my Vlookup function cannot find the
value in the table. In your example, it would appear that whatever
value resides in cell G9 cannot be found within Dept!A9:B157. I hope
that gets you going in the right direction.