Could you elaborate on how I would incorporate the ISNA function into the
formula? I've never used this fuction before...

Thanks,

"Robert" wrote:

On Nov 1, 12:49 pm, haynheart
wrote:
I use a lookup function in excel to pull data for selected users. When the
user is not listed in the range, the result is #n/a.

Rather than selecting each #n/a cell and clearing contents, I was wondering
if there is a function, formula or macro I can use that will just clear all
cells returning #n/a value at one time.

It would save me TONS of time every morning...

You could also use the ISNA function to check the result of vlookup
before displaying it, it effectively doubles the number of lookups so
it isn't too efficient though.