Each day I get from our 40 stores the following (via e-mail); I am able with
a Macro to import this data from the Body of the e-mail into a Sheet into the
first 4 columns.

Our price, 2.19, 2.25, 2.55
Exxon, 2.18, 2.27, 2.57
Texaco, 2.22, 2.33, 2.60
Shell, 2.31, 2.49, 2.66

On each days report - I compare todays price with yesterdays price
and if there is a difference (a change in price of any competitor) I
want to highlight the today competitor price;

Through Sumproduct() formula I'm able to match up Todays prices
with yesterdays prices - even if between days the store submits the
data is a different order, like:

Our price, 2.19, 2.25, 2.55
Texaco, 2.22, 2.33, 2.60
Shell, 2.31, 2.49, 2.66
Exxon, 2.18, 2.27, 2.57

BUT My Sumproduct() DOES NOT ALLOW If somehow the Comp Name
gets changed or mispelled, like Texeco versus Texaco or EXON versus Exxon.
Does anyone have any ideas as to how to properly MATCH such "near-matches"?

Thanks in advance...
Jim