Vlookup and If functions

[merrylaugh]

Basically I'm comparing two columns of alphanumeric characters. I'm trying to figure out what numbers in Column A also exist in column B. I want excel to look up the value in B1 in the array A1:A39548, and if the B1 value exists in that array, I want it to return the value from B1 in C1.

Will Vlookup and IF function accomplish this?

 

[Daveydoodles]

I think

=if(isnumber(match(B1,A1:A39548,0)),B1,"Not Found"

dragged down in column C should do the trick

 

[Dan Rittgers]

Basically I'm comparing two columns of alphanumeric characters. I'm trying to figure out what numbers in Column A also exist in column B. I want excel to look up the value in B1 in the array A1:A39548, and if the B1 value exists in that array, I want it to return the value from B1 in C1.

Will Vlookup and IF function accomplish this?

This is a sizable array. Is there a possibility that Column A contains duplicates?