replace N/A by a blank

[yyy]

How do i replace a #N/A that I get sometimes in a Vlookup by A blank ? or
the value if eveything is fine

TKS

[JE McGimpsey]

One way:


=IF(ISNA(MATCH(A1,Sheet2!A:A,FALSE)),"",VLOOKUP(A1,Sheet2!A:B,2,FALSE)


In article <C7212BB1-1BC7-4546-ADFD-1985ED9AE697@microsoft.com>,
yyy <yyy@discussions.microsoft.com> wrote:

> How do i replace a #N/A that I get sometimes in a Vlookup by A blank ? or
> the value if eveything is fine
>
> TKS