Quick question for the pros here! I am trying to populate data into a cell based on two dropdown menus. For example, if dropdown menu one is selected as "ALPHA" and dropdown menu two is selected as "alpha" then information will populate to the chosen cell (call it B2) from a different sheet and cell (call it sheet ALPHAalpha cell C1). There are many combinations here and I do not know how to structure the formula to allow for each of them (one at a time) to populate based on the chosen dropdown menu selection. Any ideas?