| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically filling a cell from a worksheet based on a selection
I have an invoice form in which I would like to automatically insert the
price based on the item selection in another cell. My data is a small table, 2 columns one for item, one for price. On my invoice for, I am able to select my item from a drop down box, now I would like to automatically fill the price column based on the item selection. What formula or function do I need to use. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically filling a cell from a worksheet based on a selection
Use VLOOKUP()
-- Gary''s Student - gsnu201003 "Pbrent" wrote: I have an invoice form in which I would like to automatically insert the price based on the item selection in another cell. My data is a small table, 2 columns one for item, one for price. On my invoice for, I am able to select my item from a drop down box, now I would like to automatically fill the price column based on the item selection. What formula or function do I need to use. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Automatically filling a cell from a worksheet based on a selection
Hi
Assuming your pricing data are on Sheet2 in columns A and B. Also assuming that your item selection is in column C, on sheet1 In cell D2 =IF(C2="","",VLOOKUP(C2,Sheet2!$A:$B,2,0)) -- Regards Roger Govier Pbrent wrote: I have an invoice form in which I would like to automatically insert the price based on the item selection in another cell. My data is a small table, 2 columns one for item, one for price. On my invoice for, I am able to select my item from a drop down box, now I would like to automatically fill the price column based on the item selection. What formula or function do I need to use. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically filling in a formula in a cell | Excel Discussion (Misc queries) | |||
| Filling a few cells based on the info from another worksheet. | Excel Worksheet Functions | |||
| Automatically Filling In Corresponding Data from Another Worksheet | Excel Discussion (Misc queries) | |||
| Automatically filling in cells based on another cell's content | Excel Worksheet Functions | |||
| How do I automatically hide columns in a worksheet based on a cell value? | Excel Worksheet Functions | |||
Hybrid Mode
