Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 08-17-2012, 10:09 PM
Catalin.B Catalin.B is offline Match information from 2 different columns Windows Vista Match information from 2 different columns Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

I'm afraid that cannot be done, because the the letters in column 2 are arbitrary chosen, there is no pattern in this operation... For example, American Bar Association is ABA in column 2, in another record, all 3 letters come from the same word: Accenture is ACN... All you can do is to assign an unique ID to your records, and search after this ID to accomplish your goal.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
MATCH Function namedujour Excel 1 07-20-2012 12:12 AM
Match information from 2 different columns match formatting help Lynnwork Excel 1 12-02-2011 08:39 AM
Match information from 2 different columns How to compare 2 columns with other two columns in EXECL 2007? Learner7 Excel 5 06-12-2010 09:54 AM
Match information from 2 different columns Problems with Match Theofficehedgehog Excel 3 07-26-2009 02:07 PM
Need another formula to match my last one tinkertron Excel 2 04-29-2009 02:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:45 PM.


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