LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Trying to pull up price for matching product?

Hello ... I'm sure this is a very simple issue, but I just cant figure it out!

I am creating a purcahse order and have a list of product name. I want to
cell next to it to pull the associated price for that product name.

My data is listed as:

A B
58 name1 price1
59 name2 price2
60 name3 price3
61 name 4 price4
.... 97 name40 price40

In cell C19 I have a list of all product names (A58 - A97), and in cell E19
I have the following formula:

=VLOOKUP("C19",A58:D97,4,FALSE)

I'm trying to have the formula be flexible and use ANY value it sees in C19
as the value to look up in the cells below, rather than telling it a specific
value to search for. Is this possible?

How can i get it to simply pull the associated price for the product
selected in the pull down list?

Thank you for any help!!
Michelle
 
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
Product & Price lists Aimee UMS Excel Worksheet Functions 1 August 18th 08 06:37 PM
how to set up quotes that pull from price book Piper Excel Discussion (Misc queries) 1 November 29th 07 03:01 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
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 05:26 PM.

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"