VLOOKUP and return blank if no match

[Xirom431]

Hi,

I have this formula =VLOOKUP(F3,'Device List'!E2:F814,2,FALSE), it will return #NA. How do I have it returns blank if no match found? Thanks.

 

[VoG]

Try

=IF(ISNA(VLOOKUP(F3,'Device List'!E2:F814,2,FALSE)),"",VLOOKUP(F3,'Device List'!E2:F814,2,FALSE))

 

[dave3009]

In excel 2007 +

=IFERROR(VLOOKUP(F3,'Device List'!E2:F814,2,FALSE), "")

Previous versions

=IF(ISNA(VLOOKUP(F3,'Device List'!E2:F814,2,FALSE)), "", VLOOKUP(F3,'Device List'!E2:F814,2,FALSE))

 

[Xirom431]

Thanks for a quick response VoG & Dave3009.