lollipop1471
New Member
- Joined
- Oct 18, 2016
- Messages
- 4
Hi,
I have this table:
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
Then I have:
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Spaces and sessions are drop down lists that can be changed and in the column next to sessions I would like it to find the corresponding figure from the table above it.
What's the best formula to use and how would I write it?
thanks
I have this table:
Sessions | No. of Spaces | ||
20 | 19 | 18 | |
5 | 400 | 380 | 360 |
4 | 320 | 304 | 288 |
3 | 240 | 228 | 216 |
2 | 160 | 152 | 144 |
<colgroup><col><col span="3"></colgroup><tbody>
</tbody>
Then I have:
Spaces | Sessions | ||
Day 1 | 20 | 4 | |
Day 2 | 19 | 2 | |
Day 3 | 19 | 4 | |
Day 4 | 18 | 4 | |
Day 5 | 18 | 2 | |
Total | - |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
Spaces and sessions are drop down lists that can be changed and in the column next to sessions I would like it to find the corresponding figure from the table above it.
What's the best formula to use and how would I write it?
thanks