Drop Down List populated from Index Match

**ajryan88** · 03-03-2014, 12:45 AM

Hi,

By "constants', do you mean duplicates? If so, the attached workbook should solve your problem.

The purple cells contain the array formula to create a list of items in column A that match up with duplicate entries in column B (note that the formula extends longer than it necessarily has to). I have then created a named range (called "DataList"), which takes all of the purple cells and ignores the blanks at the bottom of the list, using the OFFSET function. This named range is then the source of your data validation list in the orange cell. Note that the purple column can be hidden if necessary.

I hope this helps

P.S. Might I also add...how good is bacon and cheese!?!?!?!?

**jonesyp** · 03-03-2014, 01:26 AM

Yeah I was looking for the duplicates,

It unfortunately didn't work as I was looking for.

Currently I have used the following code and this returns just one value

=INDEX(A$1:A$4,MATCH(C$1,B$1:B$4,0))

now this gives the first value I am looking for, I just need it to populate the others in the list.

Thanks for your help

Drop Down List populated from Index Match

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Drop Down List populated from Index Match

Re: Drop Down List populated from Index Match

Thread Information

Users Browsing this Thread

Similar Threads

Correlation matrix to be populated from a 4 col table -tried if, match, and, index, arrray

[SOLVED] Index Match from a cell populated from index match

Two Drop Down List and INDEX, MATCH FUNCTION

[SOLVED] Drop-down list Populated by a Subset of a larger list

Drop-down list populated by SQL recordset?

Bookmarks

Bookmarks

Posting Permissions