Using excel if function on a pricing spreadsheet

[dthndmills]

I am trying to simplify a pricing spreadsheet that I use at work. I a
using the following criteria; the $ value of a product, the descriptio
of a product that I have on a cost page. What I want to do is when
type in the description of product X in a specific cell, I want the
value of that product returned to another specific cell.

Example: Lexan14SS (in a cell); 1.75 ($ value in another cell).
On a pricing spreadsheet I type in Lexan14SS and I want that specific
value returned to another cell. Of course though i will have mutipl
product descriptions and prices to go along with those products

Any help will be greatly appreciated

 

[Peo Sjoblom]

Put the description to the right and the value to the right in a table,
then use

=VLOOKUP(A1,Sheet2!A1:B200,2,0)

where A1 would be the cell where you type in the description and
Sheet2!A1:B200 is
the table with the description and values

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Domenic]

Hi,

You can use VLOOKUP to accomplish what you want. Set-up a table with
two columns, say on the second sheet, listing your products and
associated prices, something like this:

Product A 1.75
Product B 1.85
Product C 1.90

Then, on your first sheet, assuming that A1 is where you enter the name
of the product, put this formula in the cell you want your price
returned:

=VLOOKUP(A1,Sheet2!$A$1:$B$3,2,0)

Of course, change the range (Sheet2!$A$1:$B$3) for your table
accordingly.

Hope this helps!

 

[dthndmills]

I am still having a problem with this formula. I will try to put it ou
in a way that I am laying out my spreadsheet.

I am operating of of two worksheets:
The first worksheet has the following values:
I have a cell where I have put the cost of an item (1.75); I also hav
a cell where I have the description of that item (lexan18)

The second worksheet has the following cost of items:
lexan18 1.75
lexan316 2.75
lexan14 3.28

these are price per square foot of these items.

I would like to be able type in the description on the first workshee
and have it search the the cost sheet on the second worksheet and plac
that value in a cell on the first worksheet.

Thank

 

[Frank Kabel]

Hi
some good websites to explain the functions you'll need:
http://www.mvps.org/dmcritchie/excel/vlookup.htm
http://www.contextures.com/xlDataVal01.html

e.g. if your entry cell for the description is cell A1 on sheet1 enter
the following formula in B1:
=VLOOKUP(A1,'sheet2'!$A$1:$B$100,2,0)