A | Cells, tissues and systems |
1st | |
2nd | |
3rd | |
4rth |
<tbody>
</tbody>
I want to create a formula - in which you can use drop-down menus for cells A1 and B1. These will then, in turn, look up another table and look up the criteria in cell A1 and B2. I also want it to look at the steps (A2:A5) and return the appropriate comments for the given criteria. I know this might be a match and index formula. but struggling.
The below table is on another tab.
Index | Topic | step | comment 1 | comment 2 |
A | Cells, tissues and systems | 3rd | Multi organs | Respiration |
B | Space and the universe | 1st | Its a big place | Its expanding |
C | Chemical reactions | 2nd | Its goes bang | Whiz pop |
<tbody>
</tbody>
thanks in advance,
Ashley