Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Product & Price lists | Excel Worksheet Functions | |||
how to set up quotes that pull from price book | Excel Discussion (Misc queries) | |||
I have three tables; each table has a product and a price next to | Excel Discussion (Misc queries) | |||
Get product only when you have price and amount in stock | New Users to Excel | |||
at, if statement with text, such as if(product), then (price) | Excel Worksheet Functions |