Microsoft Office Forums

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

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
Advanced Beginner
Not Exact Match to Return a Value 		 
Join Date: Nov 2011
Posts: 96
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, 10 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


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 07:16 AM.

Contact Us - Privacy Statement - Top

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