Populating data based on Combo Box Selection

[blake8705]

Hi, I recently created a workbook with 2 sheets (3 if you count the duplicate 3rd sheet with alternate formatting of sheet 2).

I created a combo box with the developer tools ribbon, and I'm trying to make it where I can select a value from the combo box, and it displays all associated data next to the box.
I managed to somewhat achieve this by typing in the exact name, but could only get it to display 1 field to the right of my selection. After creating a combo box, it will not display anything at all.

Is there a way to select on option from the combo box, and have it display all corresponding data next to the box? I've attached a sheet with notes in red on what I'm trying to achieve if it help this question make more sense. The 3rd sheet (SWD Alt) is simply the same as the sheet SWD with different formatting. I wasn't sure which one was needed to pull all the data for my selection.


Thanks,
Blake

[LeoTaxi]

With Data Validation in A1

and this formula in E5 to copy down

Please Login or Register  to view this content.

Kind regards
Leo

[blake8705]

This worked perfectly, thank you!