Hi,
Am trying to match the client ID from a range where the client ID is associated to one or more sub-customers. From the matched ID, we need to return the YES or NO status depending on the sub-customers.
Vlookup ID, IF ID Match, look through sub-customer column
If sub-customer = Yes and...