Re: Trying to pull up price for matching product?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

50/50? Nah, not that high (nor me for that matter), back in the old days, we
had what we called the 50/50/90 rule, where if you have a 50% chance of
getting something right, then you would get it wrong 90% of the time.

:)
--
John C


"T. Valko" wrote:

Yeah, but the formula they posted shows column D so that's what I went with.
I have a 50/50 chance of getting it right!

--
Biff
Microsoft Excel MVP


"John C" <johnc@stateofdenial> wrote in message
news:94A55E08-E478-47B6-ADB7-C01094506A54@xxxxxxxxxxxxxxxx
I think his VLOOKUP is wrong. His sample data shows his prices in column B,
not D.

:-P
--
John C


"T. Valko" wrote:

One way...

=SUMIF(A58:A97,C19,D58:D97)

--
Biff
Microsoft Excel MVP


"mrajotte" <mrajotte@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7C3A54C2-CB7E-40CB-ACFB-FE986ABCB65A@xxxxxxxxxxxxxxxx
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






.

Relevant Pages

  • Re: If Statement Error
    ... CU'!D7:AX7,'Workbook Data'!$A$23*4-3 seems to pull the correct data for each ... Microsoft Excel MVP ... data from each location to pull into the Summary sheet. ... pulled is from the wrong cell. ...
    (microsoft.public.excel)
  • Re: Not sure how to do this...
    ... Microsoft Excel MVP ... I tried to build a table and then reference cells in the table inside ... Do I need to enclose the cell ... changes to the table than it is to edit the formula if /when the price ...
    (microsoft.public.excel.misc)
  • Re: Not sure how to do this...
    ... Microsoft Excel MVP ... I tried to build a table and then reference cells in the table inside the ... If I can't get the cell reference ... changes to the table than it is to edit the formula if /when the price ...
    (microsoft.public.excel.misc)
  • Re: If Statement Error
    ... How about refreshing my memory as to the eaxct cells you want to pull from. ... Microsoft Excel MVP ... pulled is from the wrong cell. ... I have each month listed on a workbook data sheet for ...
    (microsoft.public.excel)
  • Re: Help please with a lookup problem
    ... Microsoft Excel MVP ... Code Description Price ... My form sheet "DATA Sheet" has the same three columns. ... list of matching types but it also needs to pull in the price as well. ...
    (microsoft.public.excel.worksheet.functions)