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