Hello,
Welcome to the ExcelDemy forum. According to your post, you wish to get the correct formula to match the client ID from a range where the client ID is associated with one or more sub-customers using VLOOKUP, IF, and AND Statements. Please follow the below formula to execute this process...
