+ Reply to Thread
Results 1 to 6 of 6

How to get the corresponding quantity?

  1. #1
    Registered User
    Join Date
    01-21-2020
    Location
    Singapore
    MS-Off Ver
    Microsoft Office 365
    Posts
    7

    How to get the corresponding quantity?

    Hi all,

    I have two worksheets in the same workbook


    This is Worksheet A

    1A.png

    This is Worksheet B

    2A.png



    I would like to match the corresponding quantity to the corresponding grade in Worksheet A based on the Columns "Line", "Sub-Line", "Category", "Occasion", "Sub-Cat" and "Grade" in Worksheet B.

    Question: How to get the corresponding quantity?

    Many thanks!
    Last edited by TropicalMagic; 06-19-2021 at 08:03 PM.

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: How to get the corresponding quantity?

    A workbook is worth a thousand pictures and a thousand times easier to manipulate.
    See big yellow banner - how to upload your workbook.
    torachan.

  3. #3
    Registered User
    Join Date
    01-21-2020
    Location
    Singapore
    MS-Off Ver
    Microsoft Office 365
    Posts
    7

    Re: How to get the corresponding quantity?

    Hi torachan, thanks for responding! I have attached a sample workbook to the updated post!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: How to get the corresponding quantity?

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you are new, I will provide the link this time: https://www.excelforum.com/excel-gen...-quantity.html.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    01-21-2020
    Location
    Singapore
    MS-Off Ver
    Microsoft Office 365
    Posts
    7

    Re: How to get the corresponding quantity?

    I have found the solution:

    =VLOOKUP(CONCAT(B10,"-",C10,"-",E10,"-",F10,"-",D10),'Reference - Grading'!$F$4:$K$26,MATCH('Part 1 - Buying Template'!M10,'Reference - Grading'!$F$3:$K$3,0),FALSE)

    Best regards!

  6. #6
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: How to get the corresponding quantity?

    worksheet name : A
    Cell J10 array formula , Drag down

    HTML Code: 

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 04-11-2019, 12:17 PM
  2. [SOLVED] Formula to works out Full box Quantity and Part box quantity as well,
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-13-2018, 08:59 AM
  3. [SOLVED] Spliting Monthly quantity to daily quantity
    By z3162238 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 03-24-2016, 03:30 AM
  4. [SOLVED] Running total of Quantity on Hand Vs Sales Vs Quantity to Produce
    By jespo1351 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-01-2015, 07:34 AM
  5. Replies: 4
    Last Post: 01-14-2015, 07:46 AM
  6. Divide monthly Quantity into Weekly quantity ...
    By jitendra.mistry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-24-2010, 01:36 PM
  7. Replies: 5
    Last Post: 11-23-2009, 06:24 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1