Catch only "not found" with IFNA

Premium

E-109 is a new hire who isn't in the list yet. In E2, look up the department for D2 with VLOOKUP and wrap it in IFNA to show "Not listed" instead of #N/A.

E2
ABCDEF
1Employee ID Department Employee ID Department
2E-101 Sales E-109
3E-102 Finance
4E-103 IT
5E-104 HR
6E-105 Sales
7
8

Premium lesson

Unlock IFERROR and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:FILTERSORT and UNIQUE

It comes up in this mock test: Excel assessment (Indeed format)

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?