|
|
#7
05-20-2018, 02:43 PM
|
|||
|
|||
as yuo`v seen...i have two tables side by side ,company name and its symbol. I need a formula that will lookup for columns A or B in the list of column F or G. And getting the result in column H ...
The problem is that there is not always accurate match between columns, for example in column A symbol might be described AABA. and in column G registered AABA.O .. Also the company's full name is sometimes registered differently, for example column A the company's full name described -Agilent Technologies, but in column G - AGILENT TECH. If you have a solution for that i would be very happy.. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Comparing two sentences in two different columns
|
JoAndRoPo | Excel | 5 | 08-07-2014 07:44 AM |
| Error comparing and getting result of between Two columns | shilabrow | Excel | 4 | 06-19-2014 03:36 AM |
|
Comparing 2 columns of Text
|
Berk21 | Excel | 9 | 02-03-2012 12:19 PM |
|
Advanced Filter - Comparing Two Columns
|
apolloman | Excel | 5 | 07-27-2011 04:54 AM |
| macro for comparing data from 3 columns and pasting into another worksheet | ashukla | Excel | 1 | 06-24-2009 05:01 PM |
Windows 10 
Office 2016
Threaded Mode