Automatic filling of data

[Andy]

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?

 

[Don Guillett]

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.

 

[Gord Dibben]

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

 

[Andy]

Never mind. I was able to find it - VLOOKUP