Removing Reference Errors

[jtaylo13]

So I have a list of email addresses that changes depending on a pivot table.
Sometimes this list will contain a reference error because it is hooked up to the pivot table. Is there a way to remove all the reference errors from the list so that I am left with just the valid email address cells?

Thanks.

 

[swinglow]

we need more info about your data.

Do you have a list of names with vlookups to the pivot table? what causes the reference error? if you're using vlookups you could do something like:

=if(iserror(vlookup(...)),"",vlookup(...))