milleniummanp7
New Member
- Joined
- Sep 5, 2013
- Messages
- 4
Hey Folks,
Looking for some help with a bit of logic I'm stuck on. I've done this before, and for the life of me I can't remember how.
In Sheet 1, I have two cells that I populate manually with the values I'm looking for. In the case of the example I've provided, I've said I'm looking for country England, and region south-west.
Also in Sheet 1, down below this table I have a Summary table. It's referencing Sheet 2, with the intention being to search the table and return Yes or No based on whether a single record matches the criteria.
So I've set the country to England and the Region to South-West.
In sheet two, record 00001 matches this criteria. Therefore, I want to return Yes in the country and region match field.
Essentially, I'm saying IF Sheet1!B1 is found in Sheet2!B:B and Sheet1!B2 is found in Sheet2!C:C on the same same row in Sheet then Sheet1!B4 is Yes
Can anyone explain how I can do this? I think it's a combo of INDEX/MATCH but really stuck here.
Many thanks!
Sheet 1
<tbody>
</tbody>
<tbody>
</tbody>
Sheet 2
<tbody>
</tbody>
Looking for some help with a bit of logic I'm stuck on. I've done this before, and for the life of me I can't remember how.
In Sheet 1, I have two cells that I populate manually with the values I'm looking for. In the case of the example I've provided, I've said I'm looking for country England, and region south-west.
Also in Sheet 1, down below this table I have a Summary table. It's referencing Sheet 2, with the intention being to search the table and return Yes or No based on whether a single record matches the criteria.
So I've set the country to England and the Region to South-West.
In sheet two, record 00001 matches this criteria. Therefore, I want to return Yes in the country and region match field.
Essentially, I'm saying IF Sheet1!B1 is found in Sheet2!B:B and Sheet1!B2 is found in Sheet2!C:C on the same same row in Sheet then Sheet1!B4 is Yes
Can anyone explain how I can do this? I think it's a combo of INDEX/MATCH but really stuck here.
Many thanks!
Sheet 1
A | B | |
1 | Country | England |
2 | Region | South-West |
<tbody>
</tbody>
A | B | |
4 | Country and Region Match? | Yes |
<tbody>
</tbody>
Sheet 2
A | B | C | |
Record | Country | Region | |
1 | 00001 | England | South-West |
2 | 00002 | England | North-East |
3 | 00003 | England | North-West |
4 | 00004 | Scotland | West |
5 | 00005 | Wales | North |
6 | 00006 | Wales | East |
<tbody>
</tbody>