A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to?



 
 
Thread Tools Display Modes
  #1  
Old April 27th, 2010, 07:16 PM posted to microsoft.public.excel.worksheet.functions
Rebecca[_7_]
external usenet poster
 
Posts: 3
Default How to?

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
  #2  
Old April 27th, 2010, 07:41 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
 
Posts: 1,245
Default How to?

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
  #3  
Old April 27th, 2010, 07:43 PM posted to microsoft.public.excel.worksheet.functions
Joe User[_2_]
external usenet poster
 
Posts: 757
Default How to?

"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)
  #4  
Old April 27th, 2010, 07:51 PM posted to microsoft.public.excel.worksheet.functions
Russell Dawson[_2_]
external usenet poster
 
Posts: 173
Default How to?

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

  #5  
Old April 27th, 2010, 08:13 PM posted to microsoft.public.excel.worksheet.functions
Rebecca
external usenet poster
 
Posts: 284
Default How to?

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)

  #6  
Old April 27th, 2010, 08:20 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default How to?

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


  #7  
Old April 27th, 2010, 08:37 PM posted to microsoft.public.excel.worksheet.functions
Joe User[_2_]
external usenet poster
 
Posts: 757
Default How to?

"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)

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:20 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.