VLOOKUP function.

Assumes three columns are A to C

Dropdown is in D1

In E1 =VLOOKUP(D1,$A$1:$C$20,2,FALSE)

In F1 =VLOOKUP(D1,$A$1:$C$20,3,FALSE)


Gord Dibben MS Excel MVP


On Wed, 17 Mar 2010 14:51:01 -0700, 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?