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
----
|