Vlookup based on Drop down fails
Not Merged cells. I am pretty sure that it is a Data Validation drop
down list, but I am not sure. I did not create this spreadsheat, I am
being asked to build a couple of gnarly formulas based on these boxes,
and I have not worked with data validation boxes too much.
One thing I noticed is that I can grab and drag this thing and drop it
between cells, etc. So it does notr appear to be a cell at all. It has
a name, Drop DOWN 14. Would I referece it by that? IF so, how?
T. Valko wrote:
Another thought...
Are you using a Data Validation drop down list or are you using a Combo Box
list?
|