?
Solved

Excel comparing 2 columns to closest match

Posted on 2014-08-26
2
Medium Priority
?
183 Views
Last Modified: 2014-09-01
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.
0
Comment
Question by:GulfIT
2 Comments
 
LVL 5

Accepted Solution

by:
NARANTHIRAN earned 2000 total points
ID: 40285349
Hi,
       Try Add-in Fuzzy Lookups..

http://www.microsoft.com/en-us/download/details.aspx?id=15011
0
 

Author Closing Comment

by:GulfIT
ID: 40296970
Done
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question