remove #N/A from results so it just shows and empty cell

[danno_mbk]

Hi there,
simple one I think,
I have a VLOOKUP running, but I get #N/A as a result, how do I remove that so I have an empty cell ? I jave done it many years ago and the file its on is long gone...

=VLOOKUP($B13,'data from WL'!$A$5:$M$19,2,FALSE)

I cant remember where it goes.,

cheers
Dan

 

[fairwinds]

Hi,

Try:

=IF(ISNA(VLOOKUP($B13,'data from WL'!$A$5:$M$19,2,FALSE)),"",VLOOKUP($B13,'data from WL'!$A$5:$M$19,2,FALSE))

 

[danno_mbk]

thankyou