Exclude #N/A

[DavidLloyd100]

Hi

Im using the following formula vlookup(D6,'Nav Data'!$D$7:$H$82,2,FALSE) but i would like it that if the formula retirns #N/A the cell is blank. Does anyone now how does do this?

Any help much appreciated !

Cheers

cHRIS

 

[SteveO59L]

if(iserror(vlookup(D6,'Nav Data'!$D$7:$H$82,2,FALSE)),"",vlookup(D6,'Nav Data'!$D$7:$H$82,2,FALSE))

 

[Mike Blackman]

Hi,

You can use;

=IF(ISNA(VLOOKUP(D6,'Nav Data'!$D$7:$H$82,2,0)),"",VLOOKUP(D6,'Nav Data'!$D$7:$H$82,2,0))

 

[Colin Legg]

Hi,

This should do the trick:

=IF(ISNA(MATCH(D6,'Nav Data'!$D$7:$D$82,0)),
    "",VLOOKUP(D6,'Nav Data'!$D$7:$E$82,2,FALSE))