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.