+ Reply to Thread
Results 1 to 5 of 5

subtotals value can be vlookup by another worksheet

  1. #1
    BB
    Guest

    subtotals value can be vlookup by another worksheet

    Is subtotals value a text field ? Why can't I vlookup the value from other
    worksheet?

    Any solution? so I can lookup the subtotals value.

    Need helps urgently...

    Thank you,

  2. #2
    Peo Sjoblom
    Guest

    Re: subtotals value can be vlookup by another worksheet

    I don't understand the question, what do you mean by that? Subtotals as in
    data>subtotal is a number, it can be either a sum but if the values to be
    totaled are text then it will count those values and it uses the subtotal
    formula function which looks like

    =SUBTOTAL(9,Range)

    for sum

    or

    =SUBTOTAL(3,Range)

    for count

    if you are using a value from the for a lookup and you'll get a #N/A error
    then most likely you have more decimals than is shown by the formatting so
    what you believe to be a match is not

    --

    Regards,

    Peo Sjoblom

    Excel 95 - Excel 2007
    Northwest Excel Solutions
    www.nwexcelsolutions.com
    "It is a good thing to follow the first law of holes;
    if you are in one stop digging." Lord Healey


    "BB" <[email protected]> wrote in message
    news:[email protected]...
    > Is subtotals value a text field ? Why can't I vlookup the value from
    > other
    > worksheet?
    >
    > Any solution? so I can lookup the subtotals value.
    >
    > Need helps urgently...
    >
    > Thank you,




  3. #3
    Marcelo
    Guest

    RE: subtotals value can be vlookup by another worksheet

    Hi, subtotal value can be vlookup, assuming that you have a table
    Col A Col B
    a 1
    a 1
    a 1
    a 1
    a Total 4
    b 3
    b 2
    b 6
    b Total 9

    use =Vlookup("a Total",a2:b90,0)

    hth
    regards from Brazil
    Marcelo


    "BB" escreveu:

    > Is subtotals value a text field ? Why can't I vlookup the value from other
    > worksheet?
    >
    > Any solution? so I can lookup the subtotals value.
    >
    > Need helps urgently...
    >
    > Thank you,


  4. #4
    BB
    Guest

    RE: subtotals value can be vlookup by another worksheet

    Here is my problem:

    I have sheet #1 contains part no. A with on hand qty 10 pcs=> book qty.
    col 1 col. 2
    part no. book qty
    A 10


    Now we are doing physical count - I have a new sheet #2 => it subtotal part
    no. A (it has 3 count tags on this part) with subtotal qty 25pcs
    The result subtotal shown on sheet#2:
    part no. tag qty
    A 1 20
    A 2 3
    A 3 2
    A Total 25 => this is a subtotal line



    I would like to use sheet #1 and vlookup phy qty associate part no. A data
    from sheet #2:

    col. 1 col. 2 col. 3
    part no. book qty physical qty
    A 10 25 -> this data from vlookup on
    sheet #2 subtoal value.

    However, it always shown col. 3 - #N/A, it won't lookup subtotal qty from
    part no. A

    Please reply.

    Thank you,
    BB


    "Marcelo" wrote:

    > Hi, subtotal value can be vlookup, assuming that you have a table
    > Col A Col B
    > a 1
    > a 1
    > a 1
    > a 1
    > a Total 4
    > b 3
    > b 2
    > b 6
    > b Total 9
    >
    > use =Vlookup("a Total",a2:b90,0)
    >
    > hth
    > regards from Brazil
    > Marcelo
    >
    >
    > "BB" escreveu:
    >
    > > Is subtotals value a text field ? Why can't I vlookup the value from other
    > > worksheet?
    > >
    > > Any solution? so I can lookup the subtotals value.
    > >
    > > Need helps urgently...
    > >
    > > Thank you,


  5. #5
    BB
    Guest

    Re: subtotals value can be vlookup by another worksheet

    Here is my problem:

    I have sheet #1 contains part no. A with on hand qty 10 pcs=> book qty.
    col 1 col. 2
    part no. book qty
    A 10


    Now we are doing physical count - I have a new sheet #2 => it subtotal part
    no. A (it has 3 count tags on this part) with subtotal qty 25pcs
    The result subtotal shown on sheet#2:
    part no. tag qty
    A 1 20
    A 2 3
    A 3 2
    A Total 25 => this is a subtotal line



    I would like to use sheet #1 and vlookup phy qty associate part no. A data
    from sheet #2:

    col. 1 col. 2 col. 3
    part no. book qty physical qty
    A 10 25 -> this data from vlookup on
    sheet #2 subtoal value.

    However, it always shown col. 3 - #N/A, it won't lookup subtotal qty from
    part no. A

    Please reply.

    Thank you,
    BB

    "Peo Sjoblom" wrote:

    > I don't understand the question, what do you mean by that? Subtotals as in
    > data>subtotal is a number, it can be either a sum but if the values to be
    > totaled are text then it will count those values and it uses the subtotal
    > formula function which looks like
    >
    > =SUBTOTAL(9,Range)
    >
    > for sum
    >
    > or
    >
    > =SUBTOTAL(3,Range)
    >
    > for count
    >
    > if you are using a value from the for a lookup and you'll get a #N/A error
    > then most likely you have more decimals than is shown by the formatting so
    > what you believe to be a match is not
    >
    > --
    >
    > Regards,
    >
    > Peo Sjoblom
    >
    > Excel 95 - Excel 2007
    > Northwest Excel Solutions
    > www.nwexcelsolutions.com
    > "It is a good thing to follow the first law of holes;
    > if you are in one stop digging." Lord Healey
    >
    >
    > "BB" <[email protected]> wrote in message
    > news:[email protected]...
    > > Is subtotals value a text field ? Why can't I vlookup the value from
    > > other
    > > worksheet?
    > >
    > > Any solution? so I can lookup the subtotals value.
    > >
    > > Need helps urgently...
    > >
    > > Thank you,

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1