Conditional formatting of a vlookup cell showing #N/A

[Frequentflyer]

I've used a vlookup formula and we have a #N/A in that cell prior to it's lookup. I'm trying to conditional format that cell so that we cannot see the "#N/A".

Can anyone lead me to a solution as to how I can hide the "#N/A" either by using conditional formatting or another way.

Thanks

[romperstomper]

You can use an IF function:
=IF(ISNA(your_vlookup_function),"",your_vlookup_function)

[Frequentflyer]

Thank you, worked flawlessly.