Dear Experts,

Please help for the following condition:

1. I have one sheet "A" which contain of database, the field structure as
follows:

Field A = Date
Field B = SN
Filed C ...

I have a lot of records, which can contains the same SN (Serial Number) but
with different Removal Date.

2. on the other worksheet...i create the following field

COL A = SN
COL B = First Removal Date
COL C = Second Removal Date.
COL D = Third Removal Date.

Please guide to which function i should use? As i use VLOOKUP, it will be go
the first occurance of the date removal...(the result works properly in FIELD
B), but not on Column C, D, etc.

thank you for your kind help and TIA.

respectfully,
andri