Lookup a Value and Return Multiple Results

Ok, now I see what's happening.

Hmmm...

That's a tricky one. I'll have to think about this for a while.

I'll get back to you!

Ok, a few options...

1. Use an event macro to generate the summary list. Whenever you enter S/L in the code column then the macro will automatically add the corresponding info to the summary list. This method eliminates the need for any formulas.

2. Use an event macro to add a time stamp on the left side data area whenever you enter S/L in the code column. Then you can use a formula to generate the summary list based on chronological order.

3. Enter the replacement name on the left side data area. Then, the formula will bring the corresponding replacement name to the summary area.

I'm not much of programmer so you'll need someone else to help you with 1 and 2.