Results 1 to 5 of 5

Thread: Using MATCH()?

  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Unanswered: Using MATCH()?

    Hi all of you

    I have one problem, I need your help.

    I have a sheet with the below data
    TABLE 1 TABLE 2
    INDEX Q'TY PRICE TOTAL INDEX Q'TY TOTAL AVG
    1 100 2 200 12 SUM(B3+B4) SUM(D3+D4)
    2 200 3 600 13 SUM(B3+B5) SUM(D3+D5)
    3 300 4 1,200 14 SUM(B3+B6) SUM(D3+D6)
    4 400 5 2,000 15
    5 500 6 3,000 23
    24
    25
    34
    35
    123 SUM(B3+B4+B5) SUM(D3+D4+D6)

    Problem is to solve as
    The function in column "Q'TY" in table 2 will lookup the number (value) in colume "INDEX" in table 2 to colume "INDEX" in table 1
    then calculate the quantity. In my case as number 12 in colum "INDEX" in table 2 is a combination between number 1 and 2, so SUM(B3+B4)

    Similarly to the culume "TOTAL" in table 2

    Please, anyone can help to solve this function, VBA, or macro

    Thanks in advance!

    You can also to download file here to understand
    mediafire. com/file/ghqyrj340lb/Book2.zip

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy and welcome.

    Is this part of your homework?

    Are the labels already assigned? The reason I ask, you should not use labels that are assigned names in Excel. In this case Index as a column heading can cause problems with INDEX the function. It probably won't but just as a general practice, this should be avoided.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Mar 2009
    Location
    Worthing, UK
    Posts
    16
    Hi

    Upload your file in this forum please, so I can have a look. Your link doesn't work.

    Cheers



    Quote Originally Posted by timgiaiphap
    Hi all of you

    I have one problem, I need your help.

    I have a sheet with the below data
    TABLE 1 TABLE 2
    INDEX Q'TY PRICE TOTAL INDEX Q'TY TOTAL AVG
    1 100 2 200 12 SUM(B3+B4) SUM(D3+D4)
    2 200 3 600 13 SUM(B3+B5) SUM(D3+D5)
    3 300 4 1,200 14 SUM(B3+B6) SUM(D3+D6)
    4 400 5 2,000 15
    5 500 6 3,000 23
    24
    25
    34
    35
    123 SUM(B3+B4+B5) SUM(D3+D4+D6)

    Problem is to solve as
    The function in column "Q'TY" in table 2 will lookup the number (value) in colume "INDEX" in table 2 to colume "INDEX" in table 1
    then calculate the quantity. In my case as number 12 in colum "INDEX" in table 2 is a combination between number 1 and 2, so SUM(B3+B4)

    Similarly to the culume "TOTAL" in table 2

    Please, anyone can help to solve this function, VBA, or macro

    Thanks in advance!

    You can also to download file here to understand
    mediafire. com/file/ghqyrj340lb/Book2.zip

  4. #4
    Join Date
    Mar 2009
    Posts
    2
    @shades: tks for your note.

    @VBAExpert: tks for mark. pls download it below
    Attached Files Attached Files

  5. #5
    Join Date
    Mar 2009
    Location
    Worthing, UK
    Posts
    16

    Smile

    hi.. I have downloaded your file... do it tomorrow.. yeah..

    Have a nice weekend..

    Cheers

    VBAExpert

Posting Permissions

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