Ask Your Question

How to create data validity list from a search function [closed]

asked 2012-06-21 17:59:00 +0100

gdayton gravatar image

updated 2013-01-28 07:28:52 +0100

qubit gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-16 19:00:54.081109

1 Answer

Sort by » oldest newest most voted

answered 2012-06-21 23:36:46 +0100

m.a.riosv gravatar image

I think VLOOKUP() isn't proper to do in data validity.

Try: INDEX($B$1:$IV$4;MATCH(A8;$A$1:$A$4;0))

to select the list of values $B$1:$IV$4 in the row in which A8 is located.

edit flag offensive delete link more


@gdayton -- Does this answer work for you?

qubit gravatar imagequbit ( 2013-03-13 09:45:24 +0100 )edit

Question Tools

1 follower


Asked: 2012-06-21 17:59:00 +0100

Seen: 608 times

Last updated: Jun 21 '12