Help with Cross-Criteria in Multiple Columns

[HelpMeWithExcelPlease]

Hi all,

I'm hoping there is a simple answer to this that I just haven't been able to think of. I simplified my issue into the two tables below, the first being my raw data table and the second being the basic reporting dashboard that I am building out.

Raw Data Table:

Unique ID	State 1	State 2	State 3	Impact?
1	Texas			No
2	California	Texas		Yes
3	Colorado	Kansas	California	Yes
4	Maine	New York	Colorado	No

<tbody>
</tbody>

Reporting Dashboard:

State	Impact?
Texas	Yes
California	Yes
Colorado	Yes
Kansas	Yes
Maine	No
New York	No

<tbody>
</tbody>

The formula I do not know how to create is whatever formula will fill out my "Impact?" column on my reporting dashboard. Is it a VLOOKUP with conditions? An IF Statement? Any help on this issue would be greatly appreciated, thanks in advance!

 

[jarjarbingie]

Hi all,

I'm hoping there is a simple answer to this that I just haven't been able to think of. I simplified my issue into the two tables below, the first being my raw data table and the second being the basic reporting dashboard that I am building out.

Raw Data Table:

Unique ID	State 1	State 2	State 3	Impact?
1	Texas			No
2	California	Texas		Yes
3	Colorado	Kansas	California	Yes
4	Maine	New York	Colorado	No

<tbody>
</tbody>

Reporting Dashboard:

State	Impact?
Texas	Yes
California	Yes
Colorado	Yes
Kansas	Yes
Maine	No
New York	No

<tbody>
</tbody>

The formula I do not know how to create is whatever formula will fill out my "Impact?" column on my reporting dashboard. Is it a VLOOKUP with conditions? An IF Statement? Any help on this issue would be greatly appreciated, thanks in advance!

assuming table 1 is in Sheet1 and table 2 is in Sheet2:

B2 = IF(SUM(IF((Sheet1!$B$2:$D$5=$A2)*(Sheet1!$E$2:$E$5="Yes"),1,0))>0,"Yes","No") press CTRL+SHIFT+ENTER