How to?

[Rebecca]

I have a work sheet that has lots of prices from things that we do and I am
wanting to put it into a page where if say B4 is Cookies then the price for
Cookies automatically pops up in C4, but I dont know how to go about doing
this. Please help. Excel 2007

 

[Glenn]

I have a work sheet that has lots of prices from things that we do and I am
wanting to put it into a page where if say B4 is Cookies then the price for
Cookies automatically pops up in C4, but I dont know how to go about doing
this. Please help. Excel 2007

http://www.contextures.com/xlFunctions02.html

 

[Joe User]

I have a work sheet that has lots of prices from things
that we do and I am wanting to put it into a page where
if say B4 is Cookies then the price for Cookies
automatically pops up in C4, but I dont know how to go
about doing this.

We could provide better help if you provided some details. If Sheet1!A1:A10
contains cookie names and Sheet1!B1:B10 contains corresponding prices, then
put the following formula into C4:

=if(B4="", "", vlookup(B4,Sheet1!A1:B10,2,0)

 

[Rebecca]

This is what I have. 1 sheet named Price list on this sheet I have about 300
types of lumber and material each type of lumber and material has a set
price. On the sheet I am trying to put together is to select a type of lumber
and when I select that type it will automatically put in the set price in the
next column.

=IF(B4="","",VLOOKUP(B4,'GP by job'!A75:B121,2,0)) this gives me #N/A

Let me know if you need further explaining...

 

[Gord Dibben]

See help on VLOOKUP

Or go to Debra Dalgleish's VLOOKUP info site.

http://www.contextures.on.ca/xlFunctions02.html

Note you can download a sample workbook.


Gord Dibben MS Excel MVP

 

[Joe User]

This is what I have. 1 sheet named Price list on this
sheet I have about 300 types of lumber and material
each type of lumber and material has a set price.

Hmm.... Your original posting said you were dealing with cookies. It does
not matter. But it would be nice if you got your story straight. ;-)

On the sheet I am trying to put together is to select
a type of lumber and when I select that type it will
automatically put in the set price in the next column.

=IF(B4="","",VLOOKUP(B4,'GP by job'!A75:B121,2,0))
this gives me #N/A

Read the VLOOKUP help page. #N/A usually indicates that the value of B4
could not be found in 'GP by job'!A75:A121.

But you said the sheet with the price list is called "Price List". So at a
minimum, I think you want:

=IF(B4="","",VLOOKUP(B4,'Price List'!A75:B121,2,0))

I am ass-u-me-ing that 'Price List'!A75:A121 is the lumber/material type,
and 'Price List'!B75:B121 is the corresponding price.

However, A75:A121 does not sound like "about 300" entries.

Moreover, note that each "type" name in 'Price List'!A75:A121 must be unique
(distinctive). I am concerned that if you mix "lumber" and "material" types,
there is a possibility for conflicts in the type names.

Be sure to avoid that problem. If you cannot and you need help solving the
problem, post a follow-up in this discussion.


----- original message -----