HI Friends! I am looking for a simple formula that will pull all the information from a row based on the cell value in one of the columns. See the attached file for reference. I would like to return all the information from the sheet "Showroom Floor" into the sheet "Results". Essentially, if i select an option from the list (Cell D3 in sheet "Results") all of the rows and their information from sheet "Showroom Floor" will appear in the appropriate columns of sheet "Results". To further explain, if "Cabinetry" was selected in D3 of sheet "Results" then the chart below that cell would return the information of from rows 6, 8, 13, 27 of sheet "Showroom Floor". I think it has to do with the Index formula but i can't seem to figure it out. Any help, thank you!
Bookmarks