Vlookup, index??

I have a drop down list located in cell d7 containing 156 items. This list is identical to a range of cells in a column (Column D) of a database (B13:AF264). To the right of the drop down list, (cells E7:M7) is a range of individual cells that I would like to return values retrieved from the database. So that whatever selection is made in the drop down list, the formula looks for the corresponding value in Column D, and returns the selected results within that database row to cells E7:M7. I'm operating Excel 2007 and there would be far too many nested IF functions in addition to being time consuming and inefficient. Would VLOOKUP, INDEX, or some other function be more appropriate? If so, how do I construct the formula arguments to accomplish my task?

vlookup sounds like exactly what you're looking for.

Please Login or Register  to view this content.

where A1 is wherever your dropdown list is, d13:af264 is your dataset and the number 2 is the number of columns away from d you want to display values for. (if you want to pull everything from E7 to M7 you want to change that number in the subsequent columns. this might be easiest accomplished by numbering the row above your vlookup and pointing to that cell instead.