Can FILTER replace every VLOOKUP?

No. FILTER is for multiple matching rows and requires Microsoft 365. VLOOKUP still fits single-value lookups and older Excel versions.

Why do I see #SPILL with FILTER but #N/A with VLOOKUP?

Different errors — #SPILL means the output range is blocked; #N/A means no match was found. See our FILTER spill and #N/A guides.

UNIQUE + SORT often beats both for dynamic lists. VLOOKUP returns one value; FILTER returns all matches.

FILTER vs VLOOKUP

Choose between FILTER and VLOOKUP when retrieving Excel data, especially when you need one result versus multiple matching rows.

Use FILTER when you need multiple matching rows or dynamic results. Use VLOOKUP for a single value from a structured lookup table.

FILTER can return #CALC! when no matches are found unless you provide an if_empty argument.
VLOOKUP returns #N/A when it cannot find a match unless wrapped with IFERROR.

Can FILTER replace every VLOOKUP? No. FILTER is for multiple matching rows and requires Microsoft 365. VLOOKUP still fits single-value lookups and older Excel versions.
Why do I see #SPILL with FILTER but #N/A with VLOOKUP? Different errors — #SPILL means the output range is blocked; #N/A means no match was found. See our FILTER spill and #N/A guides.
Which is better for dropdown source lists? UNIQUE + SORT often beats both for dynamic lists. VLOOKUP returns one value; FILTER returns all matches.