# Thread: Using MATCH()?

1. Registered User
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

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

2. Registered User
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.

3. Registered User
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

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

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

4. Registered User
Join Date
Mar 2009
Posts
2

@VBAExpert: tks for mark. pls download it below

5. Registered User
Join Date
Mar 2009
Location
Worthing, UK
Posts
16
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
•