Forum Discussion
Lookup values based on 2 different search criteria
I am using Excel 2013 I oversee multiple retail locations with various retail brands in each Some brands appear in more than one location I have surveyed all retailers across all locations in one...
First correct word Location in sheet Survey Response. Then you can use these formulas:
- Sheet Location 1, 2, 3
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
Thank you Ilir for your support