Solved

# Excel lookup then fill in datas

Posted on 2011-04-26
270 Views
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
Question by:candychan611

LVL 6

Expert Comment

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

Brandon
0

LVL 6

Expert Comment

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

LVL 6

Accepted Solution

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

Author Comment

Hi,

The Cartons is according to SHEET MITEM, COLUMN  I.

Thx
0

Author Comment

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

LVL 40

Expert Comment

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 Comment

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

LVL 40

Expert Comment

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 Closing Comment

Sloved some of questions.
0

## Join & Write a Comment Already a member? Login.

### Suggested Solutions

With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

#### 728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

#### Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!