Hi All,
Lets imagine I have two Columns A,B.
A
Bob
Elephant
Brokenwood
Laser
B
Az. Elephant Co
Bob's Market Ltd.
Brokenwood Ultimate Patio
Laserjet Enterprises
Column A has a partial match of a complete cell in column B. How can I use Column A and lookup Column B to pull the best most...