So the cell I'm using as the second dropdown is in worksheet Main, cell B7, and when I tried to change the source of B7 from =INDIRECT(A7) to =EVALUATE(Main!$A$7) it gives me a formula error message