Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to create data validity list from a search function

Hello, I'm trying to create a dropdown list using Data Validity. I would like the dropdown list to be populated based on returned search results using a VLOOKUP or similar function. The list should be populated by searching for the contents of cell A2 within worksheet 1, and be the contents of cells in Column C that correspond with instances of A2.

It seems that this would be possible entering a VLOOKUP function as an array in the Data Validity box. However, Data Validity doesn't seem to like arrays, or I'm simply doing it wrong. Can anyone suggest a way for me to make this work?

Thanks and regards, Gary

click to hide/show revision 2
retagged

How to create data validity list from a search function

Hello, I'm trying to create a dropdown list using Data Validity. I would like the dropdown list to be populated based on returned search results using a VLOOKUP or similar function. The list should be populated by searching for the contents of cell A2 within worksheet 1, and be the contents of cells in Column C that correspond with instances of A2.

It seems that this would be possible entering a VLOOKUP function as an array in the Data Validity box. However, Data Validity doesn't seem to like arrays, or I'm simply doing it wrong. Can anyone suggest a way for me to make this work?

Thanks and regards, Gary