I have a drop down list with 100 options to select from. The list of 100 items is on sheet 2 and each item has 4 adjacent cells. What I need is when an item is selected from the drop down list on sheet 1 value of the 4 cells adjacent to the selected item on sheet 2 appear in the adjacent 4 cells on sheet 1. Any help would be greatly appreciated as I am going crazy over here. Thanks.