| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup based on Drop down fails
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? |
| 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
