Re: lookup i think!

From: Roger Govier (roger_at_technology4uNOSPAM.co.uk)
Date: 02/09/04 

Date: Mon, 9 Feb 2004 15:56:46 -0000

Hi Imran

Yes you can
 =VLOOKUP(A2,Sheet2!$A$2:$B$4,3,0)

Change the 2 to 3.
This tells VLookup to return the value in the 3rd column to the right of the
value "looked up", where column column 1 is the column containing the lookup
value. 

-- 
Regards
Roger Govier
"Imran S" <isheikh@inceptconsulting.com> wrote in message
news:e4b4fc75.0402090737.7c898e67@posting.google.com...
> 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