I'm using VLookup in a worksheet that then needs to perform a count of the column values.
The problem is that for every row where the lookup target is missing from the array the lookup is returning "#N/A" which is then stopping the count from working.
I'm not sure how to stop this from happening. Any ideas?
Thanks in anticipation.
Bookmarks