# Vlookup

#### Silvermini63

##### Active Member
If I have a Vlookup formula how can I get it to have a blank field instead of returning #N/A when there is no match.

=VLOOKUP(A14,Data!A:C,3,FALSE)

Thank you ### Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

#### Andrew Fergus

##### MrExcel MVP
Hi

Try this :

=IF(ISNA(VLOOKUP(A14,Data!A:C,3,FALSE)), "", VLOOKUP(A14,Data!A:C,3,FALSE))

HTH, Andrew

#### Silvermini63

##### Active Member
Thanks worked a treat #### Silvermini63

##### Active Member

=IF(\$F\$1=1,VLOOKUP(A14,Data!A:S,14,FALSE),IF(\$F\$1=2,VLOOKUP(A14,Data!A:S,15,FALSE),IF(\$F\$1=3,VLOOKUP(A14,Data!A:S,16,FALSE),IF(\$F\$1=4,VLOOKUP(A14,Data!A:S,17,FALSE),IF(\$F\$1=5,VLOOKUP(A14,Data!A:S,18,FALSE),IF(\$F\$1=6,VLOOKUP(A14,Data!A:S,19,FALSE)))))))

#### Andrew Fergus

##### MrExcel MVP
Hi

=IF(ISNA(VLOOKUP(A14,Data!A:S,13 + \$F\$1,FALSE)), "", VLOOKUP(A14,Data!A:S,13 + \$F\$1,FALSE))

Andrew

#### Silvermini63

##### Active Member
Thanks you are a genius Replies
4
Views
72
Replies
0
Views
45
Replies
4
Views
67
Replies
4
Views
82
Replies
2
Views
23