VLOOKUP from a pivot with Patient ID with contact dates and referral dates

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

Please post a small sample file with example(s) of expected results.

Click "Go Advanced" then Paper Clip icon

Hi

Does this explain what I need to do?

Thanks

Try this in C2

=IF(A2,IFERROR(INDEX(ContactData!$B$2:$B$36,SMALL(IF((ContactData!$A$2:$A$36=A2)*(ContactData!$B$2:$B$36>B2),ROW($A$2:$A$36)-ROW($A$2)+1,""),1)),"No contact"),"")

Enter with Ctrl+shift+enter

Copy down