imdex match in raw, raw, column?

[Lukas C]

hi her's my table

Name	Totals	Row Type	Day	Primary Job	Shift Start Date	Shift Start Time	Shift End Time
Smith, John	37.5	None	Sun		07/05/2017
Smith, John	37.5	Shift	Mon		08/05/2017	3:00 PM	11:00 PM
Smith, John	37.5	Shift	Tue		09/05/2017	3:00 PM	11:00 PM
Smith, John	37.5	Shift	Wed		10/05/2017	3:00 PM	11:00 PM
Smith, John	37.5	Shift	Thu		11/05/2017	3:00 PM	11:00 PM
Smith, John	37.5	Shift	Fri		12/05/2017	3:00 PM	11:00 PM
Smith, John	37.5	None	Sat		13/05/2017
Smith, James	37.5	None	Sun		07/05/2017
Smith, James	37.5	Shift	Mon		08/05/2017	2:00 PM	5:00 PM
Smith, James	37.5	Shift	Tue		09/05/2017	2:00 PM	5:00 PM
Smith, James	37.5	Shift	Wed		10/05/2017	2:00 PM	5:00 PM
Smith, James	37.5	Shift	Thu		11/05/2017	2:00 PM	5:00 PM
Smith, James	37.5	Shift	Fri		12/05/2017
Smith, James	37.5	None	Sat		13/05/2017	2:00 PM	5:00 PM

<colgroup><col span="8"></colgroup><tbody>
</tbody>

can i make excel to find looking mane in column A and then look for date in column F to return column G?
example:
Smith, John on 12/05/17 = 3:00 PM ?

 

[steve the fish]

Heres a way. Put your table in A1:H15. Put 'Smith, John' in K1, '12/05/2017' in L1. Then try this:

=INDEX($G$2:$G$100,MATCH(1,INDEX(($A$2:$A$100=K1)*($F$2:$F$100=L1),0),0))

 

[Lukas C]

Thx it make sense I'll do try after break, I assume it's... match(k1,index...?

 

[Lukas C]

Heres a way. Put your table in A1:H15. Put 'Smith, John' in K1, '12/05/2017' in L1. Then try this:

=INDEX($G$2:$G$100,MATCH(1,INDEX(($A$2:$A$100=K1)*($F$2:$F$100=L1),0),0))

thx works like a charm