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

	A	B
1	Pt No
2	visit title	000 Baseline
3	002/40349	04/05/2018
4	004/40350
5	005/40351
6	006/08935
7	007/40352
8	008/20222

<tbody>
</tbody>

Patient Visit Sheet

	A	B	C
1	002/40349	005 3 mth follow up	06/07/2018
2	002/40349	004 1 Mth follow up	01/06/2018
3	002/40349	002 Post Procedure	05/05/2018
4	002/40349	000 Baseline	04/05/2018
5	002/40349	001 Procedure	04/05/2018
6	004/40350	005 3 mth follow up	06/06/2018
7	004/40350	000 Baseline	04/05/2018
8	007/40352	randomisation	11/05/2018

<tbody>
</tbody>

 

[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.