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

Attached Files

Demo.xlsx (8.8 KB, 15 views)