+ Reply to Thread
Results 1 to 5 of 5

Match Cell Values

  1. 06-19-2021, 10:57 AM #1
    TropicalMagic
    TropicalMagic is offline
    Registered User
    Join Date
    01-21-2020
    Location
    Singapore
    MS-Off Ver
    Microsoft Office 365
    Posts
    7

    Match Cell Values

    Hi all,

    I have two worksheets in the same workbook


    The first screenshot is Worksheet A

    3A.png

    The second screenshot is Worksheet B

    4A.png


    Question: How to match SIZE PERCENTAGES numbers according to the columns “Line”, “Sub-Line”, “Category”, “Sub-Category”, “Occasion” and “Size Pack”?

    For example, Worksheet A Column “S1” J10 cell value should be 18%, following the tabular data demarcated in red borders in both Worksheets A and B.

    Many thanks!
    Reply With QuoteRegister To Reply
  2. 06-19-2021, 11:00 AM #2
    AliGW
    AliGW is online now
    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
    80,981

    Re: Match Cell Values

    How does this request differ to your original query?

    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.
    Reply With QuoteRegister To Reply
  3. 06-19-2021, 11:16 AM #3
    AliGW
    AliGW is online now
    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
    80,981

    Re: Match Cell Values

    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.mrexcel.com/board/thread...alues.1174231/.)
    Reply With QuoteRegister To Reply
  4. 06-20-2021, 04:09 AM #4
    TropicalMagic
    TropicalMagic is offline
    Registered User
    Join Date
    01-21-2020
    Location
    Singapore
    MS-Off Ver
    Microsoft Office 365
    Posts
    7

    Re: Match Cell Values

    I have found a working solution:

    =(VLOOKUP(CONCAT(B10,"-",C10,"-",E10,"-",F10,"-",D10,"-",L10),'Worksheet2'!$G$9:$O$44,MATCH('Worksheet1'!$O$9,'Worksheet2'!$G$9:$O$9,0),FALSE))*N10

    Cheers
    Reply With QuoteRegister To Reply
  5. 06-20-2021, 04:11 AM #5
    AliGW
    AliGW is online now
    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
    80,981

    Re: Match Cell Values

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using a Index + Match array with a cell that has multiple values to match against.
    By psunursingguy21 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-01-2019, 12:22 AM
  2. [SOLVED] Sort values in ascending order, match each value in cell and pull values to match
    By bjnockle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-27-2018, 06:21 AM
  3. [SOLVED] Sum cell values into another sheet IF values in cells from two sheets match
    By RaDoubleD in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-26-2018, 09:41 PM
  4. [SOLVED] Using LEFT inside INDEX-MATCH to find values that match first 5 letters of referenced cell
    By Big.Moe in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-26-2017, 04:46 PM
  5. [SOLVED] Match a cell value in another sheet and copy values below the cell (Index Match)
    By naga in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-17-2017, 03:14 AM
  6. Look Up To Columns, if Match The Same Values Paste to Relevant Cell Values to Another Cell
    By pvsvprasad in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-11-2016, 01:02 AM
  7. [SOLVED] compare cell value with range of values and match row values with header
    By bujji1305 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-08-2012, 12:19 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1