View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phil Smith Phil Smith is offline
external usenet poster
 
Posts: 50
Default 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?