THANKS MAX!!!
That did it! You've just saved me 3 days work!!!!!!
Damon

"Max" wrote:

Put in D2:
=IF(ISNA(MATCH(A2,B:B,0)),"",INDEX(C:C,MATCH(A2,B: B,0)))

Oops, missed out these lines:

Any IDs in col A unmatched with col B (if any) will return blanks: ""

Its also assumed that col B (ID REF LIST) does not contain any duplicate
items
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----