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