| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Req help matching values across columns in Excel
I have a worksheet that has over 13,000 records. Column A contains company
names; Column B contains the parent company name, if any was listed. I can filter column B to nonblanks or use a filter drop down box. I need to find all the cases where any name in column A matches the name in Column B. For example, if colum B says Smith Management LLC, I need to find Smith Management in column A. There are several hundred names in Column B after filtering to nonblanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Req help matching values across columns in Excel
Just use Vlookup, as in:
=vlookup(a2,B:B,1,false) and copy down. If it returns #N/A, then there was no match. -- Regards, Fred "Richard B" wrote in message ... I have a worksheet that has over 13,000 records. Column A contains company names; Column B contains the parent company name, if any was listed. I can filter column B to nonblanks or use a filter drop down box. I need to find all the cases where any name in column A matches the name in Column B. For example, if colum B says Smith Management LLC, I need to find Smith Management in column A. There are several hundred names in Column B after filtering to nonblanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and paste special - values into new excel file | Excel Discussion (Misc queries) | |||
| Matching values from two columns and making a third column with the results - possible? | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| How do i copy columns of data in notepad into microsoft excel? | New Users to Excel | |||
| Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
Linear Mode
