Populating Cells Based on Single Cell Selection

[dantmaldo]

I have an excel sheet that I need to pull information from. Right now I have a drop-down menu that pulls from a sheet, and in that sheet it has 7 other columns of information that is associated with it (every selection has those 7 pieces of information tied to it). I'm trying to figure out a way that when I pull up a selection, it will also pull up the other information attached to it. Also, I'm trying to do it in a way that isn't in a straight row across.I'm trying to select a piece of data from a list, and when it comes up pull all the data that I have associated with it in it's row in another sheet. I'm also trying to format the sheet so it's not one long row and maybe span a couple rows.

Thanks for the help.

[cbatrody]

Hi,

Please post a sample template of your workbook using "Go Advanced" option.

[dantmaldo]

example.png

Here is an image of what I'm trying for. The ID will be what's selected from the drop-down and all of the info fields will be populated from the ID selection. The Columns would just be a title for the field that it is showing.


Thanks

[dantmaldo]

Thanks, I uploaded an image.

[dantmaldo]

SampleBook.xlsx

Hi,

Please post a sample template of your workbook using "Go Advanced" option.

Done!

[fletch77776]

I am trying to find a solution to this same problem. Have you had any luck yet?

[dantmaldo]

Yea I used a vlookup for the first Column of information then I did a concatenating index and a left to filter the information through. Thanks though!