Vlookup

[Silvermini63]

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

 

[Andrew Fergus]

Hi

Try this :

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

HTH, Andrew

 

[Silvermini63]

Thanks worked a treat

 

[Silvermini63]

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]

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

 

[Silvermini63]

Thanks you are a genius