Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Populate cells with a unit price
For business purposes. I would like to put an item or model # in one cell and
have the price for this particular item automatically populate the cell to it's right. because each sale could be different I want to the form to populate the unit price for any item that I input in a particular cell Hope this makes sense Thanks |
#2
|
|||
|
|||
Hi Luka
You need to take a look at the VLOOKUP function. You will find an easy explanation at Debra Dalgleish's site http://www.contextures.com/xlFunctions02.html -- Regards Roger Govier "luka" wrote in message ... For business purposes. I would like to put an item or model # in one cell and have the price for this particular item automatically populate the cell to it's right. because each sale could be different I want to the form to populate the unit price for any item that I input in a particular cell Hope this makes sense Thanks |
#3
|
|||
|
|||
Thanks Roger
I've printed these instructions that you suggest and I hope that I will be able to follow them. "Roger Govier" wrote: Hi Luka You need to take a look at the VLOOKUP function. You will find an easy explanation at Debra Dalgleish's site http://www.contextures.com/xlFunctions02.html -- Regards Roger Govier "luka" wrote in message ... For business purposes. I would like to put an item or model # in one cell and have the price for this particular item automatically populate the cell to it's right. because each sale could be different I want to the form to populate the unit price for any item that I input in a particular cell Hope this makes sense Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
populate a limited # of cells with a set value | Excel Worksheet Functions | |||
I wish to automatically populate cells with list data when a item. | Excel Discussion (Misc queries) | |||
populate cells with data from another sheet | Excel Worksheet Functions | |||
How to populate formula in range of vertical cells to next colum | Excel Worksheet Functions |