VBA Code to look for ID number in two sheets (Novice here)

[coolhanddan]

Hi,

I would like to look at ID numbers in two worksheets, (sheet1 and sheet2) and if the number (in column A) occurs in both, to put a marker on one of them, called lets say (INDV). I have tried a couple of ways, but I am making a mistake somewhere.

Any advice?

Daniel

 

[John Davis]

Maybe:

=IF(ISNA(VLOOKUP(A2,Sheet2!A2:A7,1,FALSE)),"","INDV")

 

[coolhanddan]

Thanks, but something isnt working. It says that I do not have enough resources to complete, Sheet 1 has 18000 and B has about 4.

 

[John Davis]

Did you test it on a smaller range too see if it works at all? Also don't forget your dollar signs.

=IF(ISNA(VLOOKUP(A2,Sheet2!$A$2:$A$7,1,FALSE)),"","INDV")