data validation/dropdown from non adjacent rows in list

[si1128]

I have a data look-up issue that I would appreciate some help with.

I have a lookup table using many attributes (columns) to describe my items. Attributes might be datasheet, size, colour, texture and age. Each row or combination of attributes is given a unique choice number.

I also have a query area with similar columns. In many cases the set of attributes in the query area is incomplete, leading to more than one possible choice number. I wish to present the user with a dropdown of the possible choice numbers from the matching set of attributes.

I can handle the scenario where the possible choices lie in adjacent rows (described elsewhere in these pages) but not where they end up scattered across the lookup table eg row 2, 4 and 6, or 10 and 13.

I'm looking for a formula solution.

 

[Somendra Misra]

Hi,

Welcome to chandoo forum.

See the attached file. It uses helper cells in range X3:AC5.

Regards,

 

[si1128]

Hi,

Welcome to chandoo forum.

See the attached file. It uses helper cells in range X3:AC5.

Regards,

Thanks, looks great.
Si

 

[John Jairo V]

Hi @si1128 (and @Somendra Misra... again, glad to share post with you)

All the credits for the Solution to @Somendra Misra. I change the formula extract. Blessings!

 

[Somendra Misra]

@John Jairo V

It's my pleasure to share the space here with great guys like you.

Regards,