Comparing 2 columns with numbers, letters and alphanumeric values

[btthornhill]

Hi I am looking to get help with this... I have 2 columns i want to find out which items match in each column and put the matching value in column c. I have tried Vlookup and continue to get an N/A .. I tried countif and I get either an N/A or a value error. I have tried turning the cells into text but that is not working either.. please help.

column A has about 1700 rows and column B has about 4000


MOST CELLS ARE 6-7 VARIABLES.. satrting with either 01, 02, 03 with 4-5 letters following or have a 6 digit number or 6 letter value.

 

[Jonmo1]

Welcome to the board.

It's not quite clear what you're trying to do
What do you mean by this?

I have 2 columns i want to find out which items match in each column and put the matching value in column c.

Are you wanting to know which values exist in both columns?
But not necessarily on the same row right?

Try this in C2 and filled down to the end of data in column B
=IF(COUNTIF(A:A,B2),B2,"")