Matching Values in Two Columns

  • Thread starter Thread starter John
  • Start date Start date
J

John

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
 
--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
 
Back
Top