Using excel if function on a pricing spreadsheet

D

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
 
P

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
 
D

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!
 
D

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
 
Top