How to have formula recognize a table from a cell in Excel

How to have formula recognize a table from a cell in Excel

I'm using the averageifs function in excel and am trying to have it
recognize that I want to input a column reference. I have a dropdown table
so that if someone wants to find a value in my table, they can
automatically see it. In C11:C14 I have the dropdown values. Everything
works except C14 which references a column in a table in a different
worksheet. I've tried inputting "Master!Table1[Sum 10%]" into C14, but the
formula won't recognize that I am trying to call a column. Any thoughts?
Thanks!
=AVERAGEIFS(C14, Table1[Division],C13, Table1[Product Domain], C12,
Table1[Lead Source], C11)