hi,

I am using a lookup table to bring the value from one workshreet to another.
My lookup_value is slightly different than value_table_array. Below ae some
examples.

How can I match value to the table as they are the same customer?

Lookup Value Value_table_array

First American Title Co First American
Raytheon Company. Raytheon Co.
Charles River Lab Charles River
Endologix Endologix Inc
Sanford Health Sanford Health
Schering Schering Corporation.
TBC Parent TBC Parent Holding
Texas Health Resources Texas Health Resources
The Hertz Corp The Hertz


Dinesh