Creating an lookup price-list

[Digit]

I am trying to build a lookup list in excel but unable to decide how to
proceede ?

Let me try to illustrate the problem here:

I have a price-list workbook which has data like below:

Header Row -> Name Brand Packing Price
Data Row 1 -> Horlicks Nestle 500 g $10.00
Data Row 2 -> Britannia Nestle 500 g $3.99
Data Row 3 -> Taj Mahal ITC 250 g $7.78
Data Row 4 -> Seaking Grasim 100 ml $4.23

I want to create another worksheet where users can select Names from a
dropdown and automaticall the brand, packaging and price column would
be filled.

Basically the invoice worksheet will use price-list worksheet as the
source.

The lookup could be like if someone types just a -> the drop down list
should contain all name entries which contain a - anywhere in the text.

Is this possible in Excel ? Can you great minds please help me.
Thanks.

 

[Don Guillett]

This involves more of a project vs a question.
Set up a list box from the forms menu tied to a cell that uses an offset
formula to find the value desired.

 

[JulieD]

Hi

see comments in-line (marked by *******)

Cheers
JulieD

I am trying to build a lookup list in excel but unable to decide how to
proceede ?

Let me try to illustrate the problem here:

I have a price-list workbook which has data like below:

Header Row -> Name Brand Packing Price
Data Row 1 -> Horlicks Nestle 500 g $10.00
Data Row 2 -> Britannia Nestle 500 g $3.99
Data Row 3 -> Taj Mahal ITC 250 g $7.78
Data Row 4 -> Seaking Grasim 100 ml $4.23

I want to create another worksheet where users can select Names from a
dropdown

********
you can use data / validation for this - see
www.contextures.com/tiptech.html
for details
*********
and automaticall the brand, packaging and price column would

be filled.

**********
use VLOOKUP for this see http://www.contextures.com/xlFunctions02.html
for details
*********

Basically the invoice worksheet will use price-list worksheet as the
source.


The lookup could be like if someone types just a -> the drop down list
should contain all name entries which contain a - anywhere in the text.

*******
not sure this is possible with drop down lists in excel ... someone else
might have an insight here
********