Finding the closest value and matching
Hi , I need help on matching names and finding the closest values.
eg :
Col A
John Brown
Stevie Wonder
Jennifer Lopez
Col B
John Kennedy
Stevie K Brown
Lopez Jennifer
Col C - should give me answers
False
True
True
the sheet lookup for the matching value from B to A .
HOpe anyone can help. Thanks.
I'll start you off check this
I'll start you off
check this out:
http://excelexperts.com/Excel-Tips-Reverse-a-name