Re: lookup i think!

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

From: Imran S (isheikh_at_inceptconsulting.com)
Date: 02/09/04 

Date: 9 Feb 2004 07:37:17 -0800

Hi,

i have another question. if i add another column to my table in ***
2. e.g. see below.

poduct cost price selling price

red paint 10 20
green paint 20 30
blue paint 30 40

and when i put the formula in *** 1 instead of just putting the cost
price lookup in a cell could i have the selling price also appear for
the same lookup in the next column along?

regards

imran

"Roger Govier" <roger@technology4uNOSPAM.co.uk> wrote in message news:<#nLs0fk7DHA.1936@TK2MSFTNGP12.phx.gbl>...
> Hi Imran
>
> If your data is on Sheet2 in cells A2:B4 and your Selection from the drop
> down validation is on Sheet 1 in cell A2, put this formual in Sheet1 cell B2
>
> =VLOOKUP(A2,Sheet2!$A$2:$B$4,2,0)
> Change ranges to suit
>
> --
> Regards
> Roger Govier
> "Imran S" <isheikh@inceptconsulting.com> wrote in message
> news:e4b4fc75.0402080521.41d690e4@posting.google.com...
> > Hi I am trying to set up a simple function.
> >
> > i want a list of paints see example below. I have managed to create a
> > list using a validation function. What i can't seem to do is to
> > display a price to the right of the item. So when i select an item
> > from the list it picks a price which i store in the same workbook as
> > the products list and it should appear in the cell to the right. For
> > example if someone picks red paint then the price for that appears in
> > the same row, one or two rows to the right. I want to link the
> > product with a price.
> >
> >
> > red paint 10.00
> > blue paint 34.00
> > green paint 90.00
> >
> > Please can someone help. Thank you.
> >
> > Regards,
> >
> > Imran

Quantcast