I have a work book with two worksheets.
the master data tab and a summary table tab
I need a formula that can do a vlookup so using an id number in my summary table, locate that id number in the master table it will appear multiple times and then I need it to look at another column in my master data and count if for that id number the other column has a specific text string so for example.
for id number A09669 there are a count of 3 entries for the action a written comment and for the same ID a count of 1 entry for the Action Kept Behind
please see attached