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?