Hi
I am trying to create a drop list from Column A. When i select something
from that list I want it to return the entire row the cell is linked to. For
example:

Cell A1 contains the number 1, Cell A2 the number 2, Cell A3 the number 3
and Cell A4 the number 4. If i select number 2 from the drop down list (Cell
A2) I want it to return the valuse in Cell B2, B3, and B4 in the adjacent
cells.

Thanks And Regards