I'm trying to set up a dropdown menu that choose a site number (hospitals) and the cell next to the linked cell does a vlookup from a list (same list that the site numbers come from). The problem is that for every value it returns #N/A because the link cell is converted to a text value and not a number.

How do I set this link cell to never be text?

The strange thing is that it works perfectly with the other dropdown aka "List Box" (the one with scroll arrows). But I like the functionality of the "Combo box" because it compresses to one cell size after selecting your value.