• Status: Solved
• Priority: Medium
• Security: Public
• Views: 315
• Last Modified:

# Excel lookup then fill in datas

Hi Experts,

Attached File , first i type  contract number at  CELL O20  in one of the sheet ---ma mb mc md ua ub uc ud, then will generate the results .

Samples available at ' Sheet ma'   and ' Sheet ua'     Cell O33: Q35   , O36 : O53.

In case of  Contract no.25729  ,more then six items  matched  , then  sum all  quantity  to fill in Cell   O43  & O53 .

Regards
Stanley
sa-ORIGINAL-.xlsm
0
candychan611
Asked:
• 4
• 3
• 2
1 Solution

Commented:
i'm not seeing how the number of cartons is calculated.......??

Brandon
0

Commented:
on sheet 'ma' i put this formula in Cell O36 and drug down:

=SUMIFS(¿¿_MPO_D[QTY],¿¿_MPO_D[PO_NO],ma!\$O\$20,¿¿_MPO_D[DESC],ma!Q36)

And put this formula in cell 43:

=SUM(O36:O41)&" DZ"

i think that gets you part way to where you want to go.....

now we just have to figure out how you want the cartons calculated....i think....

Brandon

0

Commented:
the characters didnt come accross, see attached.....
Copy-of-sa-ORIGINAL-.xlsm
0

Author Commented:
Hi,

The Cartons is according to SHEET MITEM, COLUMN  I.

Thx
0

Author Commented:
SHEET MITEM, COLUMN  I. IS  THE  TOTAL QUANTITY OF PER CARTON
0

Commented:
Stanley, we will be happy to help, but what is the question? what is the specific problem you need our help to resolve? something specific that does not work as expected?
0

Author Commented:
Hi, i want generate a  MACRO that will generate the result as  attached  file   (i've show in  RED )
0

Commented:
Experts usually are effective in collective brainstorming specific difficulty when you are working on a project; if you need someone to do a project for you from start to finish, even a small one, dedication becomes more important. You will achieve the best result by selecting an expert who appears competent in the given area, and seeing if he has button "hire me" in his profile.
0

Author Commented:
Sloved some of questions.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

## Featured Post

• 4
• 3
• 2
Tackle projects and never again get stuck behind a technical roadblock.