What formula would return the date on these two sheets

[Tigs1966]

I have two sheets, the first one is called "Forecast" and the second one is called "Patient Visits". I want to complete cell B3 with the corresponding date from the patient visits tab on the forecast sheet once cells on patient visits have been matched to the patient number 002/40349 and the visit title "000 baseline". Is this possible.

Forecast Sheet
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Pt No[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]visit title[/TD]
[TD]000 Baseline[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]002/40349[/TD]
[TD]04/05/2018[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]004/40350[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]005/40351[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]006/08935[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]007/40352[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]008/20222[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Patient Visit Sheet

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]002/40349[/TD]
[TD]005 3 mth follow up[/TD]
[TD]06/07/2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]002/40349[/TD]
[TD]004 1 Mth follow up[/TD]
[TD]01/06/2018[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]002/40349[/TD]
[TD]002 Post Procedure[/TD]
[TD]05/05/2018[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]002/40349[/TD]
[TD]000 Baseline[/TD]
[TD]04/05/2018[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]002/40349[/TD]
[TD]001 Procedure[/TD]
[TD]04/05/2018[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]004/40350[/TD]
[TD]005 3 mth follow up[/TD]
[TD]06/06/2018[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]004/40350[/TD]
[TD]000 Baseline[/TD]
[TD]04/05/2018[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]007/40352[/TD]
[TD]randomisation[/TD]
[TD]11/05/2018[/TD]
[/TR]
</tbody>[/TABLE]

 

[alansidman]

Re: I want to know what formula would return the date on these two sheets please, any help would be appreciated

In B3 {=INDEX('Patient Visit'!$C$1:$C$8,MATCH(1,(A3='Patient Visit'!$A$1:$A$8)*(Forecast!$B$2='Patient Visit'!$B$1:$B$8),0))}
entered by holding down the ctl key the shift key and the enter key. Do not enter the curly brackets manually.

Here is a link to understand

https://exceljet.net/formula/index-and-match-with-multiple-criteria

 

[Tigs1966]

Re: I want to know what formula would return the date on these two sheets please, any help would be appreciated

In B3 {=INDEX('Patient Visit'!$C$1:$C$8,MATCH(1,(A3='Patient Visit'!$A$1:$A$8)*(Forecast!$B$2='Patient Visit'!$B$1:$B$8),0))}
entered by holding down the ctl key the shift key and the enter key. Do not enter the curly brackets manually.

Here is a link to understand

https://exceljet.net/formula/index-and-match-with-multiple-criteria

Thank you for your help, much appreciated. This worked perfectly.