vlookup where a value is not found

[Pauls123]

Hi, If I have a vlookup range, eg:

=VLOOKUP(H2,$AV$1:$AX$20,3,FALSE)

and the value of H2 is not found within the specified range it gives me #N/A

How can I make it give me nothing, ie, just a blank cell,

Thanks, Paul

 

[Sektor]

=iferror(vlookup(h2,$av$1:$ax$20,3,false),"")

 

[repairman615]

hello,

Using 2007:

=IFERROR(VLOOKUP(H2,$AV$1:$AX$20,3,FALSE),"")

 

[VoG]

Try

=IF(ISNA(VLOOKUP(H2,$AV$1:$AX$20,3,FALSE)),"",VLOOKUP(H2,$AV$1:$AX$20,3,FALSE))

 

[jasonb75]

For any version

=if(isna(match(H2,$AV$1:$AV$20,0)),"",VLOOKUP(H2,$AV$1:$AX$20,3,0))

 

[Pauls123]

Brilliant, thanks gentlemen,

Regards, Paul