The title would have been too long for its real name. Searching two different columns with a set of data for each and each data match must be on the same row to be valid and add 1 to a counter.
The code I want would search Column A for bb and find 2 and on searching column C would find 3 aa but on the row match it would only give 1. Also, the Search1 and Search2 data in my setup is a validate list dropdown so it has the ability to change -- Hopefully that affects nothing. I am thinking this will be required to be in VB because a day of searching through posts on here has turned up nothing.
Search1: bb Search2: aa A B C D 1 ab x aa x 2 ac x aa x 3 bb x aa x 4 bb x ab x