The Excel INDEX function is a formula with which you can get the content of a cell based on the position in an array. The INDEX formula is very commonly used together with the MATCH formula.
This is the so called INDEX MATCH function. You can learn more about it here:
• INDEX MATCH Excel - The Better Altern...
If you wanna learn how to integrate a drop down menu, watch this tutorial:
• Excel Drop Down List 🧾✅ - How to Crea...