Hello,
I'm looking for an Excel Formula and I hope that someone can help me out with this?
I tried to draw a simplified version of the Excel below.
I'm looking for a dynamic formula which returns the required training level for a specific Team.
For example:
- For Team C
- For Training 6
--> Which Level is required?
- For Team D
- For training 4
--> Which Level is required?
I don't want to replace the column-index-num each time (as the Excel is very big), the formula needs to be dynamic.
I'm looking for a dynamic formula which returns the required training level for a specific Team.
For example:
- For Team C
- For Training 6
--> Which Level is required?
- For Team D
- For training 4
--> Which Level is required?
I don't want to replace the column-index-num each time (as the Excel is very big), the formula needs to be dynamic.
Thank you very much in advance!!
Team A | Team B | Team C | Team D | ||||||
Training 1 | Level 3 | Training 1 <strike></strike> | Level 3 | Training Session 1 <strike></strike> | Level 3 | Training Session 1 <strike></strike> | Level 3 | ||
Training 2 | Level 3 | Training 2 | Level 3 <strike></strike> | Training 2 | Level 3 <strike></strike> | Training 2 <strike></strike> | <strike></strike> Level 3 <strike></strike> | <strike></strike> | |
Training 3 | Level 3 | Training 3 <strike></strike> | <strike></strike> Level 3 <strike></strike> | <strike></strike> | |||||
Training 4 | <strike></strike> Level 3 <strike></strike> | <strike></strike> | |||||||
Training 5 <strike></strike> | Level 2 | Training 5 <strike></strike> | <strike></strike> Level 2 <strike></strike> | Training 5 <strike></strike> | <strike></strike> Level 2 <strike></strike> | Training 5 <strike></strike> | <strike></strike> Level 2 <strike></strike> | <strike></strike> | |
Training 6 | <strike></strike> Level 2 <strike></strike> | <strike></strike> | Training 6 <strike></strike> | <strike></strike> Level 2 <strike></strike> | Training 6 <strike></strike> | <strike></strike> Level 2 <strike></strike> | <strike></strike> | ||
Training 7 | <strike></strike><strike></strike> Level 1 | <strike></strike> Training 7 <strike></strike> | <strike></strike> Level 1 <strike></strike> | <strike></strike> | Training 7 <strike></strike> | Level 1 <strike></strike> | <strike></strike> | ||
Training 8 | <strike></strike> Level 1 <strike></strike> | <strike></strike> | |||||||
Training 9 | <strike></strike> Level 1 <strike></strike> | <strike></strike> |
<tbody>
</tbody>