Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatic filling of cells within a certain date range | Excel Worksheet Functions | |||
Automatic Cell Filling | Excel Discussion (Misc queries) | |||
Filling in data when... | Excel Worksheet Functions | |||
automatic filling in cells in excel | Excel Worksheet Functions | |||
Dragging for automatic filling | Excel Discussion (Misc queries) |