Vlookup - anyway to NOT show a value?

[AudriGib11]

I have a vlook up on a form but i dont want the "#N/A" to show in the field - is that possible?

I actually would like it to show BLANK unless that field is populated.

this is the formula currently in the cell:

=VLOOKUP(B85,'Price & Stock List'!$A$1:$F$48417,2,FALSE)

THANKS!!!

 

[gsistek]

try:
=IFERROR(VLOOKUP(B85,'Price & Stock List'!$A$1:$F$48417,2,FALSE),"")

 

[Aladin Akyurek]

I have a vlook up on a form but i dont want the "#N/A" to show in the field - is that possible?

I actually would like it to show BLANK unless that field is populated.

this is the formula currently in the cell:

=VLOOKUP(B85,'Price & Stock List'!$A$1:$F$48417,2,FALSE)

THANKS!!!

If on Excel 2007 or later...

=IFERROR(VLOOKUP(B85,'Price & Stock List'!$A$1:$F$48417,2,0),"")

On all systems...

Either when the expected outcome is text:

=LOOKUP(REPT("z",255),CHOOSE({1,2},"",VLOOKUP(B85,'Price & Stock List'!$A$1:$F$48417,2,0)))

Or:

=IF(ISNUMBER(MATCH(B85,'Price & Stock List'!$A$1:$A$48417,0)),VLOOKUP(B85,'Price & Stock List'!$A$1:$F$48417,2,0),"")

 

[AudriGib11]

WORKED!!! thanks!