When using this function I've found that when the function cannot find the
value it's looking for, it returns the #N/A value.

I was wondering if there is a way for it to return a blank cell instead?

I've been plyaing around trying to embed the VLOOKUP in an IF function to
get the blank, but with no luck.

Any suggestions?