Carton size and cubic feet auto calculate..

Discussion in 'Excel General' started by shawn, May 23, 2007.

  1. shawn

    shawn Guest

    I have an Excel sheet for our "Shipping Manifest". It shows how many pieces
    in a carton, carton size, cubic feet, etc.

    We have standard carton sizes we use which we've named.

    Carton A = 18 x 18 x 18 = 3.38 Cubic Feet
    Carton B = 18 x 18 x 14 = 2.63 Cubic Feet
    Carton C = 18 x 16 x 14 = 2.33 Cubic Feet
    ... etc, on down to Carton J.

    Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
    column it will automatically enter the cubic feet for us under the cubic
    feet column? Then at the bottom of the sheet we'll have a total which will
    total up the cubic feet for us.
     
    shawn, May 23, 2007
    #1
    1. Advertising

  2. On Wed, 23 May 2007 13:50:39 -0400, "shawn" <> wrote:

    >I have an Excel sheet for our "Shipping Manifest". It shows how many pieces
    >in a carton, carton size, cubic feet, etc.
    >
    >We have standard carton sizes we use which we've named.
    >
    >Carton A = 18 x 18 x 18 = 3.38 Cubic Feet
    >Carton B = 18 x 18 x 14 = 2.63 Cubic Feet
    >Carton C = 18 x 16 x 14 = 2.33 Cubic Feet
    >.. etc, on down to Carton J.
    >
    >Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
    >column it will automatically enter the cubic feet for us under the cubic
    >feet column? Then at the bottom of the sheet we'll have a total which will
    >total up the cubic feet for us.
    >
    >


    Set up a table. Name it something like CuFtTbl.

    A 3.38
    B 2.63
    C 2.33
    ....
    J

    Then use this formula:

    =VLOOKUP(CTN_SIZE,CuFtTbl,2,FALSE)
    --ron
     
    Ron Rosenfeld, May 23, 2007
    #2
    1. Advertising

  3. shawn

    shawn Guest

    But then won't that table show up on printouts? Is there a way to put the
    table on sheet2 and have it read the data off that?

    "Ron Rosenfeld" <> wrote in message
    news:...
    > On Wed, 23 May 2007 13:50:39 -0400, "shawn" <>
    > wrote:
    >
    >>I have an Excel sheet for our "Shipping Manifest". It shows how many
    >>pieces
    >>in a carton, carton size, cubic feet, etc.
    >>
    >>We have standard carton sizes we use which we've named.
    >>
    >>Carton A = 18 x 18 x 18 = 3.38 Cubic Feet
    >>Carton B = 18 x 18 x 14 = 2.63 Cubic Feet
    >>Carton C = 18 x 16 x 14 = 2.33 Cubic Feet
    >>.. etc, on down to Carton J.
    >>
    >>Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
    >>column it will automatically enter the cubic feet for us under the cubic
    >>feet column? Then at the bottom of the sheet we'll have a total which will
    >>total up the cubic feet for us.
    >>
    >>

    >
    > Set up a table. Name it something like CuFtTbl.
    >
    > A 3.38
    > B 2.63
    > C 2.33
    > ...
    > J
    >
    > Then use this formula:
    >
    > =VLOOKUP(CTN_SIZE,CuFtTbl,2,FALSE)
    > --ron
     
    shawn, May 23, 2007
    #3
  4. shawn

    shawn Guest

    So far I've tried and can't get it to work. I've tried to make a table below
    my information on sheet1.

    "Ron Rosenfeld" <> wrote in message
    news:...
    > On Wed, 23 May 2007 13:50:39 -0400, "shawn" <>
    > wrote:
    >
    >>I have an Excel sheet for our "Shipping Manifest". It shows how many
    >>pieces
    >>in a carton, carton size, cubic feet, etc.
    >>
    >>We have standard carton sizes we use which we've named.
    >>
    >>Carton A = 18 x 18 x 18 = 3.38 Cubic Feet
    >>Carton B = 18 x 18 x 14 = 2.63 Cubic Feet
    >>Carton C = 18 x 16 x 14 = 2.33 Cubic Feet
    >>.. etc, on down to Carton J.
    >>
    >>Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
    >>column it will automatically enter the cubic feet for us under the cubic
    >>feet column? Then at the bottom of the sheet we'll have a total which will
    >>total up the cubic feet for us.
    >>
    >>

    >
    > Set up a table. Name it something like CuFtTbl.
    >
    > A 3.38
    > B 2.63
    > C 2.33
    > ...
    > J
    >
    > Then use this formula:
    >
    > =VLOOKUP(CTN_SIZE,CuFtTbl,2,FALSE)
    > --ron
     
    shawn, May 23, 2007
    #4
  5. shawn

    Peo Sjoblom Guest

    Yes, you can have the table in another sheet and even hide that sheet if you
    want


    --
    Regards,

    Peo Sjoblom



    "shawn" <> wrote in message
    news:...
    > But then won't that table show up on printouts? Is there a way to put the
    > table on sheet2 and have it read the data off that?
    >
    > "Ron Rosenfeld" <> wrote in message
    > news:...
    >> On Wed, 23 May 2007 13:50:39 -0400, "shawn" <>
    >> wrote:
    >>
    >>>I have an Excel sheet for our "Shipping Manifest". It shows how many
    >>>pieces
    >>>in a carton, carton size, cubic feet, etc.
    >>>
    >>>We have standard carton sizes we use which we've named.
    >>>
    >>>Carton A = 18 x 18 x 18 = 3.38 Cubic Feet
    >>>Carton B = 18 x 18 x 14 = 2.63 Cubic Feet
    >>>Carton C = 18 x 16 x 14 = 2.33 Cubic Feet
    >>>.. etc, on down to Carton J.
    >>>
    >>>Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
    >>>column it will automatically enter the cubic feet for us under the cubic
    >>>feet column? Then at the bottom of the sheet we'll have a total which
    >>>will
    >>>total up the cubic feet for us.
    >>>
    >>>

    >>
    >> Set up a table. Name it something like CuFtTbl.
    >>
    >> A 3.38
    >> B 2.63
    >> C 2.33
    >> ...
    >> J
    >>
    >> Then use this formula:
    >>
    >> =VLOOKUP(CTN_SIZE,CuFtTbl,2,FALSE)
    >> --ron

    >
    >
     
    Peo Sjoblom, May 23, 2007
    #5
  6. shawn

    Bob I Guest

    If your "Letter" is in cell A1, then put the following in the Cell you
    want the size to appear.

    =HLOOKUP(A1,{"A","B","C";3.38,2.63,2.33},2)&" Cubic Feet"

    shawn wrote:

    > But then won't that table show up on printouts? Is there a way to put the
    > table on sheet2 and have it read the data off that?
    >
    > "Ron Rosenfeld" <> wrote in message
    > news:...
    >
    >>On Wed, 23 May 2007 13:50:39 -0400, "shawn" <>
    >>wrote:
    >>
    >>
    >>>I have an Excel sheet for our "Shipping Manifest". It shows how many
    >>>pieces
    >>>in a carton, carton size, cubic feet, etc.
    >>>
    >>>We have standard carton sizes we use which we've named.
    >>>
    >>>Carton A = 18 x 18 x 18 = 3.38 Cubic Feet
    >>>Carton B = 18 x 18 x 14 = 2.63 Cubic Feet
    >>>Carton C = 18 x 16 x 14 = 2.33 Cubic Feet
    >>>.. etc, on down to Carton J.
    >>>
    >>>Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
    >>>column it will automatically enter the cubic feet for us under the cubic
    >>>feet column? Then at the bottom of the sheet we'll have a total which will
    >>>total up the cubic feet for us.
    >>>
    >>>

    >>
    >>Set up a table. Name it something like CuFtTbl.
    >>
    >>A 3.38
    >>B 2.63
    >>C 2.33
    >>...
    >>J
    >>
    >>Then use this formula:
    >>
    >>=VLOOKUP(CTN_SIZE,CuFtTbl,2,FALSE)
    >>--ron

    >
    >
    >
     
    Bob I, May 23, 2007
    #6
  7. shawn

    shawn Guest

    Here's what I have currently..

    Sheet1 has my Shipping Manifest.

    Sheet2 has the following data from A1 to B11

    BOX CF
    A 3.38
    B 2.63
    C 2.33
    D 2.04
    E 1.56
    F 1.04
    G .65
    H .41
    I .41
    J .25

    I typed that data in, highlighted it all then converted it to a table.

    I think where I am having trouble is the "lookup value"

    I have written what Ron suggested and tried to go through the evaluate thing
    to find errors.
     
    shawn, May 23, 2007
    #7
  8. shawn

    Peo Sjoblom Guest

    You can use

    =IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0)),"Incorrect Value
    Entered",VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0)))


    replace A1 with the cell where you input the size



    or hard coded which means you don't need the table in Sheet2

    =IF(A1="","",IF(ISNA(VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0)),"Incorrect
    Value
    Entered",VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0)))



    replace A1 with the cell where you input the size





    --
    Regards,

    Peo Sjoblom

    "shawn" <> wrote in message
    news:...
    > Here's what I have currently..
    >
    > Sheet1 has my Shipping Manifest.
    >
    > Sheet2 has the following data from A1 to B11
    >
    > BOX CF
    > A 3.38
    > B 2.63
    > C 2.33
    > D 2.04
    > E 1.56
    > F 1.04
    > G .65
    > H .41
    > I .41
    > J .25
    >
    > I typed that data in, highlighted it all then converted it to a table.
    >
    > I think where I am having trouble is the "lookup value"
    >
    > I have written what Ron suggested and tried to go through the evaluate
    > thing to find errors.
    >
     
    Peo Sjoblom, May 23, 2007
    #8
  9. shawn

    shawn Guest

    Thanks. I used the hard coded method. Is there a way for this to also work
    in Excel 97-2003 format? It's not a big deal if it won't work, but three
    machines in our office aren't upgraded to Excel 2007.


    "Peo Sjoblom" <> wrote in message
    news:...
    > You can use
    >
    > =IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0)),"Incorrect Value
    > Entered",VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0)))
    >
    >
    > replace A1 with the cell where you input the size
    >
    >
    >
    > or hard coded which means you don't need the table in Sheet2
    >
    > =IF(A1="","",IF(ISNA(VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0)),"Incorrect
    > Value
    > Entered",VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0)))
    >
    >
    >
    > replace A1 with the cell where you input the size
    >
    >
    >
    >
    >
    > --
    > Regards,
    >
    > Peo Sjoblom
    >
    > "shawn" <> wrote in message
    > news:...
    >> Here's what I have currently..
    >>
    >> Sheet1 has my Shipping Manifest.
    >>
    >> Sheet2 has the following data from A1 to B11
    >>
    >> BOX CF
    >> A 3.38
    >> B 2.63
    >> C 2.33
    >> D 2.04
    >> E 1.56
    >> F 1.04
    >> G .65
    >> H .41
    >> I .41
    >> J .25
    >>
    >> I typed that data in, highlighted it all then converted it to a table.
    >>
    >> I think where I am having trouble is the "lookup value"
    >>
    >> I have written what Ron suggested and tried to go through the evaluate
    >> thing to find errors.
    >>

    >
    >
     
    shawn, May 25, 2007
    #9
  10. shawn

    Peo Sjoblom Guest

    The formula works fine in previous versions, you need to save the file in
    xls format, do a save as after hitting the office button and you'll se what
    I mean


    --
    Regards,

    Peo Sjoblom



    "shawn" <> wrote in message
    news:%...
    > Thanks. I used the hard coded method. Is there a way for this to also work
    > in Excel 97-2003 format? It's not a big deal if it won't work, but three
    > machines in our office aren't upgraded to Excel 2007.
    >
    >
    > "Peo Sjoblom" <> wrote in message
    > news:...
    >> You can use
    >>
    >> =IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0)),"Incorrect Value
    >> Entered",VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0)))
    >>
    >>
    >> replace A1 with the cell where you input the size
    >>
    >>
    >>
    >> or hard coded which means you don't need the table in Sheet2
    >>
    >> =IF(A1="","",IF(ISNA(VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0)),"Incorrect
    >> Value
    >> Entered",VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0)))
    >>
    >>
    >>
    >> replace A1 with the cell where you input the size
    >>
    >>
    >>
    >>
    >>
    >> --
    >> Regards,
    >>
    >> Peo Sjoblom
    >>
    >> "shawn" <> wrote in message
    >> news:...
    >>> Here's what I have currently..
    >>>
    >>> Sheet1 has my Shipping Manifest.
    >>>
    >>> Sheet2 has the following data from A1 to B11
    >>>
    >>> BOX CF
    >>> A 3.38
    >>> B 2.63
    >>> C 2.33
    >>> D 2.04
    >>> E 1.56
    >>> F 1.04
    >>> G .65
    >>> H .41
    >>> I .41
    >>> J .25
    >>>
    >>> I typed that data in, highlighted it all then converted it to a table.
    >>>
    >>> I think where I am having trouble is the "lookup value"
    >>>
    >>> I have written what Ron suggested and tried to go through the evaluate
    >>> thing to find errors.
    >>>

    >>
    >>

    >
    >
     
    Peo Sjoblom, May 25, 2007
    #10
  11. How to calculate carton size in cubic ft.

    How to calculate carton size in cubic ft.



    shawn wrote:

    Carton size and cubic feet auto calculate..
    23-May-07

    I have an Excel sheet for our "Shipping Manifest". It shows how many pieces
    in a carton, carton size, cubic feet, etc.

    We have standard carton sizes we use which we've named.

    Carton A = 18 x 18 x 18 = 3.38 Cubic Feet
    Carton B = 18 x 18 x 14 = 2.63 Cubic Feet
    Carton C = 18 x 16 x 14 = 2.33 Cubic Feet
    ... etc, on down to Carton J.

    Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
    column it will automatically enter the cubic feet for us under the cubic
    feet column? Then at the bottom of the sheet we'll have a total which will
    total up the cubic feet for us.

    Previous Posts In This Thread:

    On Wednesday, May 23, 2007 1:50 PM
    shawn wrote:

    Carton size and cubic feet auto calculate..
    I have an Excel sheet for our "Shipping Manifest". It shows how many pieces
    in a carton, carton size, cubic feet, etc.

    We have standard carton sizes we use which we've named.

    Carton A = 18 x 18 x 18 = 3.38 Cubic Feet
    Carton B = 18 x 18 x 14 = 2.63 Cubic Feet
    Carton C = 18 x 16 x 14 = 2.33 Cubic Feet
    ... etc, on down to Carton J.

    Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
    column it will automatically enter the cubic feet for us under the cubic
    feet column? Then at the bottom of the sheet we'll have a total which will
    total up the cubic feet for us.

    On Wednesday, May 23, 2007 2:03 PM
    Ron Rosenfeld wrote:

    Re: Carton size and cubic feet auto calculate..
    Set up a table. Name it something like CuFtTbl.

    A 3.38
    B 2.63
    C 2.33
    ....
    J

    Then use this formula:

    =VLOOKUP(CTN_SIZE,CuFtTbl,2,FALSE)
    --ron

    On Wednesday, May 23, 2007 3:03 PM
    shawn wrote:

    But then won't that table show up on printouts?
    But then will not that table show up on printouts? Is there a way to put the
    table on sheet2 and have it read the data off that?

    On Wednesday, May 23, 2007 3:07 PM
    shawn wrote:

    So far I've tried and can't get it to work.
    So far I have tried and cannot get it to work. I have tried to make a table below
    my information on sheet1.

    On Wednesday, May 23, 2007 3:07 PM
    Peo Sjoblom wrote:

    Yes, you can have the table in another sheet and even hide that sheet if you
    Yes, you can have the table in another sheet and even hide that sheet if you
    want


    --
    Regards,

    Peo Sjoblom

    On Wednesday, May 23, 2007 3:33 PM
    Bob I wrote:

    If your "Letter" is in cell A1, then put the following in the Cell you want
    If your "Letter" is in cell A1, then put the following in the Cell you
    want the size to appear.

    =HLOOKUP(A1,{"A","B","C";3.38,2.63,2.33},2)&" Cubic Feet"

    shawn wrote:

    On Wednesday, May 23, 2007 3:53 PM
    shawn wrote:

    Here's what I have currently..Sheet1 has my Shipping Manifest.
    Here's what I have currently..

    Sheet1 has my Shipping Manifest.

    Sheet2 has the following data from A1 to B11

    BOX CF
    A 3.38
    B 2.63
    C 2.33
    D 2.04
    E 1.56
    F 1.04
    G .65
    H .41
    I .41
    J .25

    I typed that data in, highlighted it all then converted it to a table.

    I think where I am having trouble is the "lookup value"

    I have written what Ron suggested and tried to go through the evaluate thing
    to find errors.

    On Wednesday, May 23, 2007 4:05 PM
    Peo Sjoblom wrote:

    You can use=IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet2!
    You can use

    =IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0)),"Incorrect Value
    Entered",VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0)))


    replace A1 with the cell where you input the size



    or hard coded which means you don't need the table in Sheet2

    =IF(A1="","",IF(ISNA(VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0)),"Incorrect
    Value
    Entered",VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0)))



    replace A1 with the cell where you input the size





    --
    Regards,

    Peo Sjoblom

    "shawn" <> wrote in message
    news:...

    On Friday, May 25, 2007 11:36 AM
    shawn wrote:

    Thanks. I used the hard coded method.
    Thanks. I used the hard coded method. Is there a way for this to also work
    in Excel 97-2003 format? It's not a big deal if it won't work, but three
    machines in our office aren't upgraded to Excel 2007.


    "Peo Sjoblom" <> wrote in message
    news:...

    On Friday, May 25, 2007 11:47 AM
    Peo Sjoblom wrote:

    The formula works fine in previous versions, you need to save the file in xls
    The formula works fine in previous versions, you need to save the file in
    xls format, do a save as after hitting the office button and you will se what
    I mean


    --
    Regards,

    Peo Sjoblom


    Submitted via EggHeadCafe - Software Developer Portal of Choice
    BOOK REVIEW: Effective C#, Second Edition [Addison Wesley]
    http://www.eggheadcafe.com/tutorial...7af-c38852b3b455/book-review-effective-c.aspx
     
    Satwinder Saluja, Apr 22, 2010
    #11
  12. How to calculate carton size in cubic ft.

    How to calculate carton size in cubic ft.



    shawn wrote:

    Carton size and cubic feet auto calculate..
    23-May-07

    I have an Excel sheet for our "Shipping Manifest". It shows how many pieces
    in a carton, carton size, cubic feet, etc

    We have standard carton sizes we use which we've named

    Carton A = 18 x 18 x 18 = 3.38 Cubic Fee
    Carton B = 18 x 18 x 14 = 2.63 Cubic Fee
    Carton C = 18 x 16 x 14 = 2.33 Cubic Fee
    ... etc, on down to Carton J

    Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
    column it will automatically enter the cubic feet for us under the cubic
    feet column? Then at the bottom of the sheet we'll have a total which will
    total up the cubic feet for us.

    Previous Posts In This Thread:

    On Wednesday, May 23, 2007 1:50 PM
    shawn wrote:

    Carton size and cubic feet auto calculate..
    I have an Excel sheet for our "Shipping Manifest". It shows how many pieces
    in a carton, carton size, cubic feet, etc

    We have standard carton sizes we use which we've named

    Carton A = 18 x 18 x 18 = 3.38 Cubic Fee
    Carton B = 18 x 18 x 14 = 2.63 Cubic Fee
    Carton C = 18 x 16 x 14 = 2.33 Cubic Fee
    ... etc, on down to Carton J

    Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
    column it will automatically enter the cubic feet for us under the cubic
    feet column? Then at the bottom of the sheet we'll have a total which will
    total up the cubic feet for us.

    On Wednesday, May 23, 2007 2:03 PM
    Ron Rosenfeld wrote:

    Re: Carton size and cubic feet auto calculate..
    Set up a table. Name it something like CuFtTbl

    A 3.3
    B 2.6
    C 2.3
    ...


    Then use this formula

    =VLOOKUP(CTN_SIZE,CuFtTbl,2,FALSE
    --ron

    On Wednesday, May 23, 2007 3:03 PM
    shawn wrote:

    But then won't that table show up on printouts?
    But then will not that table show up on printouts? Is there a way to put th
    table on sheet2 and have it read the data off that?

    On Wednesday, May 23, 2007 3:07 PM
    shawn wrote:

    So far I've tried and can't get it to work.
    So far I have tried and cannot get it to work. I have tried to make a table belo
    my information on sheet1.

    On Wednesday, May 23, 2007 3:07 PM
    Peo Sjoblom wrote:

    Yes, you can have the table in another sheet and even hide that sheet if you
    Yes, you can have the table in another sheet and even hide that sheet if yo
    wan

    -
    Regards

    Peo Sjoblom

    On Wednesday, May 23, 2007 3:33 PM
    Bob I wrote:

    If your "Letter" is in cell A1, then put the following in the Cell you want
    If your "Letter" is in cell A1, then put the following in the Cell yo
    want the size to appear

    =HLOOKUP(A1,{"A","B","C";3.38,2.63,2.33},2)&" Cubic Feet

    shawn wrote:

    On Wednesday, May 23, 2007 3:53 PM
    shawn wrote:

    Here's what I have currently..Sheet1 has my Shipping Manifest.
    Here's what I have currently.

    Sheet1 has my Shipping Manifest

    Sheet2 has the following data from A1 to B1

    BOX C
    A 3.3
    B 2.6
    C 2.3
    D 2.0
    E 1.5
    F 1.0
    G .6
    H .4
    I .4
    J .2

    I typed that data in, highlighted it all then converted it to a table

    I think where I am having trouble is the "lookup value

    I have written what Ron suggested and tried to go through the evaluate thing
    to find errors.

    On Wednesday, May 23, 2007 4:05 PM
    Peo Sjoblom wrote:

    You can use=IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet2!
    You can us

    =IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0)),"Incorrect Value
    Entered",VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0))

    replace A1 with the cell where you input the siz


    or hard coded which means you don't need the table in Sheet

    =IF(A1="","",IF(ISNA(VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0)),"Incorrect
    Value
    Entered",VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0))


    replace A1 with the cell where you input the siz



    --
    Regards

    Peo Sjoblo

    "shawn" <> wrote in message
    news:...

    On Friday, May 25, 2007 11:36 AM
    shawn wrote:

    Thanks. I used the hard coded method.
    Thanks. I used the hard coded method. Is there a way for this to also work
    in Excel 97-2003 format? It's not a big deal if it won't work, but three
    machines in our office aren't upgraded to Excel 2007.


    "Peo Sjoblom" <> wrote in message
    news:...

    On Friday, May 25, 2007 11:47 AM
    Peo Sjoblom wrote:

    The formula works fine in previous versions, you need to save the file in xls
    The formula works fine in previous versions, you need to save the file in
    xls format, do a save as after hitting the office button and you will se what
    I mean


    --
    Regards,

    Peo Sjoblom

    On Thursday, April 22, 2010 5:17 AM
    Satwinder Saluja wrote:

    How to calculate carton size in cubic ft.
    How to calculate carton size in cubic ft.


    Submitted via EggHeadCafe - Software Developer Portal of Choice
    Get Silverlight 4 Installed: Tips and Tricks
    http://www.eggheadcafe.com/tutorial...b-f54c56a64ed9/get-silverlight-4-install.aspx
     
    Satwinder Saluja, Apr 22, 2010
    #12
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. John
    Replies:
    0
    Views:
    46
  2. OcalaElaine
    Replies:
    4
    Views:
    93
    OcalaElaine
    Jun 13, 2006
  3. OcalaElaine
    Replies:
    4
    Views:
    89
    Toppers
    Jun 14, 2006
  4. Michael M

    Cubic Parabola or Cubic Spiral

    Michael M, Aug 7, 2006, in forum: Excel Worksheets
    Replies:
    0
    Views:
    91
    Michael M
    Aug 7, 2006
  5. Petec
    Replies:
    6
    Views:
    77
    Ron Rosenfeld
    Mar 3, 2009
Loading...

Share This Page