VLOOKUP if blank return blank

To check for empty cells in VLOOKUP results, you can combine the VLOOKUP function with the IF function. In the example shown, the formula in G5, copied down, is: =IF(VLOOKUP(E5,data,2,0)="","",VLOOKUP(E5,data,2,0)) where "data" is the named range B5:C11.

April 14, 2025 · 1 min · 76 words · James Williams

Table of Contents

When VLOOKUP can’t find a value in a lookup table, it returns the #N/A error.

you could use theIFNA functionorIFERROR functionto trap this error.

Note: you’re free to use thesame general approachwith theXLOOKUP function.

Excel formula: VLOOKUP with numbers and text

For example, to test for cells that literally have zero characters (i.e.

If not, return an empty string ("").

More than one condition can be tested by nesting IF functions.

Excel formula: VLOOKUP without #N/A error

The IF…

Excel formula error codes

How to use VLOOKUP

Excel formula: VLOOKUP two-way lookup

Excel formula: Merge tables with VLOOKUP

Excel formula: VLOOKUP calculate grades

Excel VLOOKUP function

Excel IF function