Apr 02 2021 01:17 AM
Apr 02 2021 01:32 AM
Please try this...
In F2
=INDEX('Survey Response'!C$2:C$34,MATCH(1,INDEX(('Survey Response'!$A$2:$A$34=$A2)*('Survey Response'!$B$2:$B$34=$B2),),0))
and then copy it across and down.
Apr 02 2021 02:02 AM
First correct word Location in sheet Survey Response. Then you can use these formulas:
in cell F2
=INDEX('Survey Response'!$C$2:$C$100,MATCH(A2&B2,INDEX('Survey Response'!$A$2:$A$100&'Survey Response'!$B$2:$B$100,),0))
in cell G2
=INDEX('Survey Response'!$D$2:$D$100,MATCH(A2&B2,INDEX('Survey Response'!$A$2:$A$100&'Survey Response'!$B$2:$B$100,),0))
both data in column F and G format as Time.
in cell H2
=INDEX('Survey Response'!$D$2:$D$100,MATCH(A2&B2,INDEX('Survey Response'!$A$2:$A$100&'Survey Response'!$B$2:$B$100,),0))
You can download my file here: https://1drv.ms/x/s!Ah_p7p0xkR5RnXQWftJ48LS0sKso?e=nQCXZe .
Hope this helps.
Regards,
IlirU
Apr 03 2021 06:16 PM
Apr 03 2021 06:17 PM
Apr 03 2021 09:13 PM
You're welcome @Gareth_Durbridge! Glad I could help.
Please take a minute to accept the post with the proposed solution as a Best Response to mark your question as Solved.