I am comparing two sets of data where a customer can have multiple products, up to about 16, each listed on a separate row. I need a formula that can compare the two lists and return a result.
If the two products (cells) match I want to return "match"
If the two products (cells) don't match but are populated (i.e. not blank) I want to return "mismatch"
If there is a product in one of the two cells but the other cell is blank I want to return "no match"
I have tried messing about with IF's and AND's but cannot seem to get the right result across all the permutations.
Thanks