+ Reply to Thread
Results 1 to 3 of 3

Table Arrangement

  1. #1
    Registered User
    Join Date
    02-06-2011
    Location
    Tel aviv, Israel
    MS-Off Ver
    Excel 2013
    Posts
    59

    Table Arrangement

    Hello good lads...
    I have an issue I can't manage to resolve in an elegant way so I turn to you.

    I have 2 tables (attached an example), in the 1st there's a list of brands (1-22), a list that can and will be rearranged every month. And in the 2nd there are the brands score per the position.

    I'm trying to arrange in the 3rd table the scores per brand – match (for example – Brand 1 should state: "1.000" in the first column, and "0.540" in the second column and so on).

    I struggled with array formulas but it got too messy so I'd appreciate your assistance.

    Thank you.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Table Arrangement

    Hello,

    You won't need an Array formula for this. You can try this simple INDEX MATCH
    Please Login or Register  to view this content.
    Paste it on B51, drag it to C51, select both B51 and C51, then drag it to row 72.
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem

  3. #3
    Registered User
    Join Date
    02-06-2011
    Location
    Tel aviv, Israel
    MS-Off Ver
    Excel 2013
    Posts
    59

    Re: Table Arrangement

    oh, that's great.
    i knew I was trying more than needed.

    thank you very much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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