Never mind. I was able to find it - VLOOKUP
--
Andy


"Andy" wrote:

I have a 3 columns of pre-defined data - Name, Cost and Sell. In another part
of the sheet I want to select from a drop-down list the name from the first
column (that part is working). Once I've selected the name I want it to
automatically fill the 2 columns to the right with the data next to the
pre-defined "name" column from "cost" and "sell". Does anyone have a
suggestion of how I might accomplish this?
--
Andy