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

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Andy" <(E-Mail Removed)> wrote in message
news:E9A607B3-4E1C-42C9-9336-(E-Mail Removed)...
>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

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 <(E-Mail Removed)>
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?

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