I have a cell with a dropdown based on a list q3:q45
I have a cell with Vlookup, data to lookup from that cell, range q3:q45

As you can see, it will be the same data, so there WILL be a match at
all times. Yes, the data range is sorted alphabetically.
If I change my lookup cell to a normal cell, cut and paste into it from
my list, the formula works.

What gives? Any Ideas?