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