Hi all,
I want the 'word' entered into cell A1 to be searched in my price list, the
item desctiption and price from that list then retuned.
ie
user inputs "apple" into cell A1
the list below is searched and correct description and price retuned and
shown in cells A2 and A3

pricelist

Banana Yellow £2
Orange Orange £2
Apple Green £1.50
Stawberry Red £3.00

so the result for "apple" being ented into cell A1 would show "Green" in
cell A2 and £1.50 into cell A3

hope this is clear, as I am a little new to this.
Thanks

Try this, Ant:
Sample file: http://www.myexpertsonline.com/freedls/pricelist.xls
How to drop-down:
http://www.officearticles.com/excel/...soft_excel.htm
How to vlookup:
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Anthony" wrote in message
...
Hi all,
I want the 'word' entered into cell A1 to be searched in my price list,
the
item desctiption and price from that list then retuned.
ie
user inputs "apple" into cell A1
the list below is searched and correct description and price retuned and
shown in cells A2 and A3

pricelist

Banana Yellow £2
Orange Orange £2
Apple Green £1.50
Stawberry Red £3.00

so the result for "apple" being ented into cell A1 would show "Green" in
cell A2 and £1.50 into cell A3

hope this is clear, as I am a little new to this.
Thanks

Vlookup will give you the functionality you describe. If you price list is a
name range (PriceList), you can use formulas similar to:

=vlookup(a1,pricelist,2,false)
=vlookup(a1,pricelist,3,false)


--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Anthony" wrote in message
...
Hi all,
I want the 'word' entered into cell A1 to be searched in my price list,
the
item desctiption and price from that list then retuned.
ie
user inputs "apple" into cell A1
the list below is searched and correct description and price retuned and
shown in cells A2 and A3

pricelist

Banana Yellow £2
Orange Orange £2
Apple Green £1.50
Stawberry Red £3.00

so the result for "apple" being ented into cell A1 would show "Green" in
cell A2 and £1.50 into cell A3

hope this is clear, as I am a little new to this.
Thanks

On Wed, 6 Jul 2005 17:03:03 -0700, "Anthony"
wrote:

Hi all,
I want the 'word' entered into cell A1 to be searched in my price list, the
item desctiption and price from that list then retuned.
ie
user inputs "apple" into cell A1
the list below is searched and correct description and price retuned and
shown in cells A2 and A3

pricelist

Banana Yellow £2
Orange Orange £2
Apple Green £1.50
Stawberry Red £3.00

so the result for "apple" being ented into cell A1 would show "Green" in
cell A2 and £1.50 into cell A3

hope this is clear, as I am a little new to this.
Thanks

A2: =VLOOKUP(A1,PriceList,2,0)
A3: =VLOOKUP(A1,PriceList,3,0)

PriceList is the range where you have your price list information stored. It
can be on the same sheet or a different sheet.


--ron

thanks for your help guys

"Anne Troy" wrote:

Try this, Ant:
Sample file: http://www.myexpertsonline.com/freedls/pricelist.xls
How to drop-down:
http://www.officearticles.com/excel/...soft_excel.htm
How to vlookup:
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Anthony" wrote in message
...
Hi all,
I want the 'word' entered into cell A1 to be searched in my price list,
the
item desctiption and price from that list then retuned.
ie
user inputs "apple" into cell A1
the list below is searched and correct description and price retuned and
shown in cells A2 and A3

pricelist

Banana Yellow £2
Orange Orange £2
Apple Green £1.50
Stawberry Red £3.00

so the result for "apple" being ented into cell A1 would show "Green" in
cell A2 and £1.50 into cell A3

hope this is clear, as I am a little new to this.
Thanks