Each client can choose 4 consultants, each consultant can choose 2 clients. The upper table shows which consultants each client choose. The lower table shows which clients each consultant choose. I want to use vlookup and functions to get result in Column G, the result of which consultant are not matched for each client. For example, for A client, A chose 1,2,3,4, but the lower table shows, consultant 1 chose A, so 1 is matched to A, however, A chose 2, but 2 didn't pick A, so 2 appeared in Result (not chosen). After this is solved, I want to compute how many times consultant chosen, how many times they are repeats in the lower table.
Solved by A. A. in 12 mins