Autofilter tp leave out #N/A in macro

Lavanya - May 27, 2010 at 07:24 AM
 Lavanya - May 28, 2010 at 05:37 AM

I have a project id in column C , which iam checking from another source data which is there in a differenr tab .So ihave a vlookup fprmulae in the column X to check if the project is present in the other source .For this column X I have applied autofilter .Now what should be the criteria in the macro , for the autofilter to filter only values and leaving out #N/A that are the endresult of the vlookup.Please help me with the code.

6 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 27, 2010 at 04:58 PM
The best and most easy way of this answer would be
start macro recorder
apply the filter
stop the recorder.

now you would have the code to use

Also you can do what Trowa suggest

=IF(ISERROR(vlookup(...)), "PROJ NOT FOUND", VLOOKUP(...))