Hello there,
I am looking for a formula that can handle returning an index value based on header names instead of index number. This is because the data source is dynamic. The location of the index value I am looking for will vary depending on the source.
There are two reliable constants:
In this scenario, I am trying to find the value of X.
Here is my spreadsheet today:
Sheet 1: (Static)
<tbody>
</tbody>
Sheet 2: (Dynamic)
<tbody>
</tbody>
Here is my spreadsheet tomorrow:
Sheet 1: (Static)
<tbody>
</tbody>
Sheet 2: (Dynamic)
<tbody>
</tbody>
And here is the data the day after tomorrow:
Sheet 1: (Static)
<tbody>
</tbody>
Sheet 2: (Dynamic)
<tbody>
</tbody>
So as you can see, the location of the data varies, as well as how many columns we are dealing with in Sheet 2. Any help with this would be greatly appreciated!
I am looking for a formula that can handle returning an index value based on header names instead of index number. This is because the data source is dynamic. The location of the index value I am looking for will vary depending on the source.
There are two reliable constants:
- Sheet 1 will remain static.
- The header names will always be the same
In this scenario, I am trying to find the value of X.
Here is my spreadsheet today:
Sheet 1: (Static)
| Team Name | Wins |
| 49ers | X |
| Cardinals | X |
| Rams | X |
| Seahawks | X |
<tbody>
</tbody>
Sheet 2: (Dynamic)
| Wins | Losses | Ties | PCT | Team Name |
| 4 | 0 | 0 | 1.000 | 49ers |
| 3 | 1 | 0 | .750 | Rams |
| 0 | 4 | 0 | .000 | Cardinals |
| 1 | 3 | 0 | .250 | Seahawks |
<tbody>
</tbody>
Here is my spreadsheet tomorrow:
Sheet 1: (Static)
| Team Name | Wins |
| 49ers | X |
| Cardinals | X |
| Rams | X |
| Seahawks | X |
<tbody>
</tbody>
Sheet 2: (Dynamic)
| Team Name | Losses | Wins | PCT | Ties | Streak |
| 49ers | 0 | 5 | 1.000 | 0 | 5 |
| Cardinals | 5 | 0 | .000 | 0 | -5 |
| Seahawks | 4 | 1 | .200 | 0 | -4 |
| Rams | 2 | 3 | .600 | 0 | -1 |
<tbody>
</tbody>
And here is the data the day after tomorrow:
Sheet 1: (Static)
| Team Name | Wins |
| 49ers | X |
| Cardinals | X |
| Rams | X |
| Seahawks | X |
<tbody>
</tbody>
Sheet 2: (Dynamic)
| Losses | Ties | Team Name | Streak | Wins | Seed | PCT |
| 2 | 0 | Rams | 1 | 4 | 5 | .667 |
| 0 | 0 | 49ers | 6 | 6 | 1 | 1.000 |
| 5 | 0 | Cardinals | 1 | 1 | 14 | .167 |
| 4 | 0 | Seahawks | 1 | 2 | 12 | .333 |
<tbody>
</tbody>
So as you can see, the location of the data varies, as well as how many columns we are dealing with in Sheet 2. Any help with this would be greatly appreciated!
