loop through EmployeeIDs, and find them on another Speadsheet

[Ronanm]

Code to loop through EmployeeIDs, and find them on another
Spreadsheet. And then when they're found, I can choose a value to return using offset.

The EmployeeIDs in Sheet1 are unique, but in sheet 2 they are duplicated.
So in my head I'm thinking...

For each Cell in sheet2(range(A1:A1000)
If Cell.value = For each Cell in sheet1(Range(A1:A5000) ....then

But that's just stupid )

 

[VoG]

Try like this

For Each cell In Sheets("Sheet1").Range("A1:A1000")
    If IsNumeric(Application.Match(cell.Value, Sheets("Sheet2").Columns("A"), 0)) Then
Next cell

 

[Ronanm]

Cheers Peter

I have used a version of that.

Appreciate it

Ronan