| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching Values in Two Columns
Can anyon epleae help?
I have two coloumns of data, column B has approx 50 and column c has approx 40,000. I wouls like a formula or function to match if any value in column B is included in Column C. Example below Column B Column C EA5321A509 EU6210B036 WM5323A007 EU5331B488 EU5331B488 ACVITAL EU5322A246 ACVITAL EU1860B002 ACF0D EU1860B012 ACFOOTER EU6210B153 EU5322A246-041 EU6210B207 EU5322A246-041 EU6210P001 EU5322A246-041 EA6211B014 EU5322A246-041 EA6211B015 EU5322A246-041 EA6211B016 EU5322A246-041 EA6211B017 EU5322A246-041 EA6211B024 EU5322A246-041 EA6200V008 EU5322A246-041 ED6211B014 EU5322A246 ED6211B015 EU5322A246-041 ED6211B016 EU5322A246-041 ED6211B017 EU5322A246-041 ED6211B022 EU5322A246-041 ED6211B024 EU5322A246-041 EA6211T006 EU5322A246-041 EU5230Y005 EU5322A246-041 WM5323A007 EU5322A246-041 EU5332B475 EU5322A246-041 WM5323A007 EU5322A246-041 EA5332B232 EU5322A246-041 WM5323A007 EU5322A246-041 EU5332B475 EU5322A246-041 EU5332B475 EU5322A246-041 Thanks, John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Matching Values in Two Columns
--Insert a column inbetween Col B and C so that 40000 data is in ColD
--In Col C cell C1 enter the below formula which will return the text if Col B data is present in ColD. Copy down the formula as required =IF(COUNTIF(D:D,B1),"Present in Col D","") If this post helps click Yes --------------- Jacob Skaria "John" wrote: Can anyon epleae help? I have two coloumns of data, column B has approx 50 and column c has approx 40,000. I wouls like a formula or function to match if any value in column B is included in Column C. Example below Column B Column C EA5321A509 EU6210B036 WM5323A007 EU5331B488 EU5331B488 ACVITAL EU5322A246 ACVITAL EU1860B002 ACF0D EU1860B012 ACFOOTER EU6210B153 EU5322A246-041 EU6210B207 EU5322A246-041 EU6210P001 EU5322A246-041 EA6211B014 EU5322A246-041 EA6211B015 EU5322A246-041 EA6211B016 EU5322A246-041 EA6211B017 EU5322A246-041 EA6211B024 EU5322A246-041 EA6200V008 EU5322A246-041 ED6211B014 EU5322A246 ED6211B015 EU5322A246-041 ED6211B016 EU5322A246-041 ED6211B017 EU5322A246-041 ED6211B022 EU5322A246-041 ED6211B024 EU5322A246-041 EA6211T006 EU5322A246-041 EU5230Y005 EU5322A246-041 WM5323A007 EU5322A246-041 EU5332B475 EU5322A246-041 WM5323A007 EU5322A246-041 EA5332B232 EU5322A246-041 WM5323A007 EU5322A246-041 EU5332B475 EU5322A246-041 EU5332B475 EU5322A246-041 Thanks, John |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Matching Values in Two Columns
In D1, enter:
=IF(COUNTIF(C:C,B1)0,"Match","") and copy down -- Gary''s Student - gsnu200908 "John" wrote: Can anyon epleae help? I have two coloumns of data, column B has approx 50 and column c has approx 40,000. I wouls like a formula or function to match if any value in column B is included in Column C. Example below Column B Column C EA5321A509 EU6210B036 WM5323A007 EU5331B488 EU5331B488 ACVITAL EU5322A246 ACVITAL EU1860B002 ACF0D EU1860B012 ACFOOTER EU6210B153 EU5322A246-041 EU6210B207 EU5322A246-041 EU6210P001 EU5322A246-041 EA6211B014 EU5322A246-041 EA6211B015 EU5322A246-041 EA6211B016 EU5322A246-041 EA6211B017 EU5322A246-041 EA6211B024 EU5322A246-041 EA6200V008 EU5322A246-041 ED6211B014 EU5322A246 ED6211B015 EU5322A246-041 ED6211B016 EU5322A246-041 ED6211B017 EU5322A246-041 ED6211B022 EU5322A246-041 ED6211B024 EU5322A246-041 EA6211T006 EU5322A246-041 EU5230Y005 EU5322A246-041 WM5323A007 EU5322A246-041 EU5332B475 EU5322A246-041 WM5323A007 EU5322A246-041 EA5332B232 EU5322A246-041 WM5323A007 EU5322A246-041 EU5332B475 EU5322A246-041 EU5332B475 EU5322A246-041 Thanks, John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up two values in different columns and return matching value | Excel Discussion (Misc queries) | |||
| Find matching values in two different columns | Excel Worksheet Functions | |||
| Matching values in 2 columns | Excel Discussion (Misc queries) | |||
| Matching values in two columns | Excel Discussion (Misc queries) | |||
| Req help matching values across columns in Excel | Excel Worksheet Functions | |||
Hybrid Mode
