Need some help pulling information

Hi!

I need some help pulling some information from one excel tab to another. Attached is a document that contains two tabs. The first tab contains a drop down where a user can select a color (cell C3). The second Tab contains a library(or table) that lists all colors, IDs and information.

I'd like for a user to select a color (ie blue) and the table auto-populate itself on the first tab. I've tried using Vlookup, but it gets messy and cluttered with multiple IDs that correspond to a color.

Can anyone help?

Thanks so much

Maybe:

Please Login or Register  to view this content.