HelpMeWithExcelPlease
New Member
- Joined
- Jul 27, 2017
- Messages
- 24
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:
<tbody>
</tbody>
Reporting Dashboard:
<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!
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!