Hi,



I've been searching for a solution to my problem for weeks without any luck so I'm hoping you guys can help!

I'll do my best to explain.

Is there a way for Vlookup to search a table array which has multiple drop down lists and return a drop down list?

Currently Vlookup searches my table and returns the current position of a list in the table, but the list functionality is gone. I'd like it return the list and let the user have the drop down functionality.

Does that make sense? Possible?

Thanks

Andrew