Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am using Excel 2007 and here is an simplified example of what I need.
Items Price Potatoes 4.35 Apples 5.55 Oranges 7.95 Onions 4.55 Carrots 3.75 Items Column is List for Valid entries in table below Prices are the numbers I want entered when I enter the Item If I enter Oranges from Dropdown List in A16 , I want Excel to automatically enter the number 7.95 3 columns over in D16,or if it is quite a bit easier, just 1 column over in cell B16 Example of table I want: My Entries: Excel Enters A16 Carrots D16 3.75 A17 Oranges D17 7.95 A18 Onions D18 4.55 A19 Onions D19 4.55 A20 Potatoes D20 4.35 Thanks so much for your help ! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change value of cell automatically if entered the wrong number | Excel Worksheet Functions | |||
Selecting from drop down list enters multiple cell data | Excel Worksheet Functions | |||
Mouse click automatically enters character into cell. | Excel Worksheet Functions | |||
How do I get data automatically entered into a cell? | Excel Worksheet Functions | |||
Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) |