I'm trying to grab information from another worksheet but when the line I'm
referencing on the other worksheet isn't available it returns the value #N/A,
which is fine but that's not what I was to display, I just want an empty cell
when it cannot find that info on the other worksheet. Here's an example of
what I'm trying to do....

=VLOOKUP(A2, names, 5, FALSE)

let's say A2 is Bob, if excel cannot find Bob in the "names" array it
returns the value #N/A. I cannot figure out how to make it return a value
that I would rather use. I've been playing with ERROR.TYPE but I can't seem
to get that to work for me because if VLOOKUP actually returns a value I get
another #N/A.