Asif Faleel
asked on
Excel comparing 2 columns to closest match
Hi,
I have 2 columns from different excel sheets i need to do a vlookup like function but do a nearest match than a exact one. I am looking at a difference of 4 charactors per lookup.
How can i do via excel.
I have 2 columns from different excel sheets i need to do a vlookup like function but do a nearest match than a exact one. I am looking at a difference of 4 charactors per lookup.
How can i do via excel.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER