I am looking for a method to match 2 similar text strings (company names) from two lists and return a value (an ID number). I've tried using the Lookup function but it returned too many errors when the "False" (close match) attribute was applied and too few results when the "True" (exact match) attribute was applied.
Does anyone know a good way to accomplish a match like this?
Attached are sample lists. For example purposes, I am trying to look up the Customer name in COL A of Sheet1 from the list in COL A of Sheet (2). I want to return the MemberID from COL B in Sheet2 and put it in COL C of Sheet1.
Thanks in advance for your help.