Vlook up question - I think ?

G

Guest

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
 
D

Damon Longworth

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
 
R

Ron Rosenfeld

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
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find a value in table 2
How to choose maximum value 7
Conditional Formatting where Matrix intersects 2
SUMIF function and cell /sheet reference 3
Help on filling empty cells with string + row() 1
Create tabs named after a group of cells? 3
Modifying the Range Nameange the names 4
Run Macro Upon Entering Data into Cell/s 3

Top