# Remove #N/A in vlookup result

###### Posted By: Anonymous

How do I modify this function so that the result will merely be a blank cell rather than having #N/A show up if B2 has nothing in that cell?

I *think* I might need something like an ISERROR check but I don’t 100% know what I’m doing.

```
=VLOOKUP(B2,Index!A1:B12,2,FALSE)
```

Thanks!

## Solution

If you only want to return a blank when B2 is blank you can use an additional IF function for that scenario specifically, i.e.

`=IF(B2="","",VLOOKUP(B2,Index!A1:B12,2,FALSE))`

or to return a blank with **any error** from the VLOOKUP (e.g. including if B2 is populated but that value isn’t found by the VLOOKUP) you can use IFERROR function if you have **Excel 2007** or later, i.e.

`=IFERROR(VLOOKUP(B2,Index!A1:B12,2,FALSE),"")`

in earlier versions you need to repeat the VLOOKUP, e.g.

`=IF(ISNA(VLOOKUP(B2,Index!A1:B12,2,FALSE)),"",VLOOKUP(B2,Index!A1:B12,2,FALSE))`

###### Answered By: Anonymous

Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.