Hi, Can do the match function, but need a condition so that if there is an
error returns 0, with below not returning anything (I have 'On error Resume Next' at top of code)

Cells(2, 10) = WorksheetFunction.Match(Cells(2, 9), Range(Cells(2, 8), Cells(10, 8)), 0)