TJE12345Copper ContributorSep 01, 2023Excel formula for lookup We have two sets of data to compare. In one set of data, cell A1 has numbers separated by commas, like this: 13010982231, 13010982232, 13011011681, 13011011682 Cell A2 has the name of the person...Show More
HansVogelaarMVPSep 01, 2023TJE12345 Try =IFERROR(INDEX(Name_Column,MATCH("*"&G2&"*",""&Number_Column,0)),"")
