Quote:
Originally Posted by xor
Could you possibly post your file here and state expected results?
|
Hi XOR,
Thanks for the reply. I made a quick Demo file. See attached.
I would like my vlookup to return a fully functional drop down list.
In my example the vlookup is searching the table for the number 1 and returns mustang, which is the current position of the drop down list within the table. The returned cell (F1) has lost the functionality of the drop down list.
I would like the drop down function to remain and be independent of the position of the drop down list in the table array.
Hope that makes sense?
Thanks!
Andrew