how to use vlookup/macro programming for this issue?state price accroding droplist

**kaisin** · 07-20-2007, 12:21 AM

okie i need help in this.am stuck at this point.

i have a database of product and price

of which

i have included the product in a dropdown list in another worksheet,

what i would want to do is that when i select the product from the dropdown list, the price will appear.

can anyone teach me how to go abt doing it?

**davesexcel** · 07-20-2007, 12:32 AM

Here's a site on VLOOKUP

http://www.contextures.com/xlFunctions02.html

as well as a quick example

select the drop down menu in A2 and notice the other cells change

the other cells have the vlookup formula C2 and D2

look at sheet 2 to see the data

**Trebor76** · 07-20-2007, 12:41 AM

Hi there,

Have a look at the formula in cell B2 on Sheet2 and if it's what your after, change the range and tab name to suit.

HTH

Robert

**kaisin** · 07-20-2007, 01:09 AM

the small attachment which u insert is exactly what i meant!!

=VLOOKUP($A$2,Sheet2!$A$1:$C$5,2,FALSE)

can u explain this?

my source is from G2 to G132 (sheet b)

my dropbox is at Sheet D (located at c7)

price to show up at Sheet D E7