I'd probably use match

if ids are in col A of sheet 1 and col C of sheet 2

in B2 = match($A2,sheet2!$C:$C,0)

puts a number in B2 which is the row where the id appears.

Posted By: watfordcanary, Jul 29, 16:12:38