Lookup date and return specific cell value from a range

[Clash]

Hi All,

Can you please help?

I have a table that has a number of new starters and corresponding appointments offered, what I originally required was to lookup the chronological date after the new start date (which Ace_XL thankfully helped me with).

However this has now been scuppered by my boss who has requested that not only lookup the date, but also add who the appointment is with, but if I do this the first array formula stops working and to tell the trust I'm not to sure how to do it anyway.

Many thanks in anticipation

Clash

[Fotis1991]

Can you pls share with us some expected results?

Also would be usefull to share the existing formula.

[rcm]

I think you only sent the required output, please include the input data

[Clash]

I have updated the file, hopefully it is now clearer.

Thanks for having a look.