Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Not Exact Match to Return a Value
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 02-19-2015, 06:58 PM
Alaska1 Alaska1 is offline Not Exact Match to Return a Value Windows 7 64bit Not Exact Match to Return a Value Office 2007
Competent Performer
Not Exact Match to Return a Value 		 
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
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not Exact Match to Return a Value Excel Formula: return a range of cells that match tinfanide Excel 4 08-30-2014 07:03 AM
Not Exact Match to Return a Value How to count even exact date 90 days redza Excel 1 09-17-2013 03:36 AM
Not Exact Match to Return a Value exact measurements for tables lolaukey Word Tables 3 08-29-2012 09:16 PM
Not Exact Match to Return a Value How to find exact phrase CabbageTree Outlook 2 05-14-2012 11:24 AM
Not Exact Match to Return a Value Link and Keep Source Formatting--not exact minny Excel 2 04-09-2012 04:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:16 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft