Hi all

I have a lot of data with referral dates of patients in one sheet and the contact dates in another. I have the referrals listed with a Patient ID. In my contact data I have a wide range of contacts both before and after the referral date. How can I lookup the first contact date after the referral when the contact dates are in a pivot table? I also have the contact data in a table but not pivoted if this would be easier? Any ideas?

Thanks

Michael