Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Product & Price lists

I am have a price list on a worksheet and then I have a statement. On the
statement I have a drop down list of all the products that they can select
from, but I want it to automatically popluate the price of that product in
the next column after they have selected the product. How do I do that?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 964
Default Product & Price lists

http://www.contextures.com/xlFunctions02.html

--


Regards,


Peo Sjoblom

"Aimee UMS" wrote in message
...
I am have a price list on a worksheet and then I have a statement. On the
statement I have a drop down list of all the products that they can select
from, but I want it to automatically popluate the price of that product in
the next column after they have selected the product. How do I do that?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
choose a product from a drop down list i need it to insert a price Barnzy Excel Worksheet Functions 6 April 12th 07 04:48 PM
I have three tables; each table has a product and a price next to Nader Excel Discussion (Misc queries) 1 January 6th 07 07:22 AM
Get product only when you have price and amount in stock Clash New Users to Excel 2 May 30th 06 10:10 PM
I need a templet for comparing product abilties & price Jack J Excel Discussion (Misc queries) 1 May 11th 06 03:43 PM
at, if statement with text, such as if(product), then (price) karenofcourse Excel Worksheet Functions 1 July 27th 05 09:52 PM


All times are GMT +1. The time now is 06:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"