Try changing the drop-down selection to see the column heading ... In cell I3, we want to tell Excel to look in Table 1 and ...

Does your large spreadsheet contain lots of blank rows that serve no purpose? Don't waste time removing these empty rows ...