Hello MVP's and other VBA pro's,
I have a problem in VBA.
I want to do a look up in a column containing dropdowns in a range (E:17, G59).
The drop down has two options, 1 is containing only blanks (from a hidden sheet, linked to the input of column A) the other is containing any text value...