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

Rebecca wrote:
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

"Rebecca" wrote:
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

You may need to explain a little more about your problem. I doubt whether
the price of Cookies is the only entry here.
If it is then
=IF(B4="cookies",1,"")
in C4 where cookies are $1.
You don't say how much they are. It would be better to have the price in
another part of the worksheet say d4 so the formula would be
-if(b4="cookies",D4,"")
The double quotes leaves the cell blank when b4 does not contain cookies.


--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Rebecca" wrote:

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

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...


"Joe User" wrote:

"Rebecca" wrote:
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)

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

On Tue, 27 Apr 2010 11:16:01 -0700, Rebecca <Rebecca
@discussions.microsoft.com wrote:

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

"Rebecca" wrote:
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 -----

"Rebecca" wrote:
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...


"Joe User" wrote:

"Rebecca" wrote:
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)