Thread: Not Exact Match to Return a Value
View Single Post
 
Old 02-19-2015, 06:58 PM
Alaska1 Alaska1 is offline Windows 7 64bit Office 2007
Competent Performer
  
Join Date: Nov 2011
Posts: 110
Alaska1 is on a distinguished road
Default Not Exact Match to Return a Value
I have two spreadsheets with company names. I need the unique ID to return the value on Sheet 2 even though the company names in both spreadsheets are not an exact match. What is the best function in excel to do this? I have attached a sample.
Attached Files
File Type: xlsx Book1.xlsx (7.9 KB, 12 views)
Reply With Quote