[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 312
  • 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:
candychan611
  • 4
  • 3
  • 2
1 Solution
 
KnutsonBMCommented:
i'm not seeing how the number of cartons is calculated.......??

Brandon
0
 
KnutsonBMCommented:
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
 
KnutsonBMCommented:
the characters didnt come accross, see attached.....
Copy-of-sa-ORIGINAL-.xlsm
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
candychan611Author Commented:
Hi,

The Cartons is according to SHEET MITEM, COLUMN  I.

Thx
0
 
candychan611Author Commented:
SHEET MITEM, COLUMN  I. IS  THE  TOTAL QUANTITY OF PER CARTON
0
 
Vadim RappCommented:
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
 
candychan611Author Commented:
Hi, i want generate a  MACRO that will generate the result as  attached  file   (i've show in  RED )
0
 
Vadim RappCommented:
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
 
candychan611Author Commented:
Sloved some of questions.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

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