| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup using a dropdwn list, check different tables based on drop | Excel Worksheet Functions | |||
| Drop Down based on a condition | Excel Worksheet Functions | |||
| vlookup formula fails to return data search item is text | Excel Worksheet Functions | |||
| drop down values based on the another drop down | New Users to Excel | |||
| vlookup fails on data from a pivot table | Excel Worksheet Functions | |||
Threaded Mode
