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...
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.
Thank you Subodh for your support
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.