Apologies for not knowing what this may be.
I have the following table and am trying to figure out if excel is even capable of indexing some value. Each number on top has 2 categories. If the desired number chosen is 34, the result should be 30 and 40 for example. If 30 is chosen, the 10 and 20 should show.
<colgroup><col span="6"></colgroup><tbody>
</tbody>
I have the following table and am trying to figure out if excel is even capable of indexing some value. Each number on top has 2 categories. If the desired number chosen is 34, the result should be 30 and 40 for example. If 30 is chosen, the 10 and 20 should show.
Enter Desired Number Here: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Category 1 last number to be shown: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Category 2 first number to be shown: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col span="6"></colgroup><tbody> </tbody> |
<colgroup><col span="6"></colgroup><tbody>
</tbody>