Vlookup

Silvermini63

Active Member
Joined
Sep 25, 2006
Messages
293
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
:)
 

Some videos you may like

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
Joined
Sep 9, 2004
Messages
5,432
Hi

Try this :

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

HTH, Andrew
 

Silvermini63

Active Member
Joined
Sep 25, 2006
Messages
293
sorry to bug but how about this one would it be the same?

=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
Joined
Sep 9, 2004
Messages
5,432
Hi

Try this instead :

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

Andrew
 

Watch MrExcel Video

Forum statistics

Threads
1,114,041
Messages
5,545,687
Members
410,698
Latest member
Wloven
Top