Autofilter tp leave out #N/A in macro
Solved/Closed
Hello,
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.
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.
Related:
- Vba filter not equal to
- Why does facebook refresh when i leave the app - Guide
- Spell number in excel without macro - Guide
- How to leave business account on tiktok ✓ - TikTok Forum
- How to leave a voice message on messenger - Guide
- Excel macro to create new sheet based on value in cells - Guide
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
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(...))
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(...))