Results 1 to 3 of 3

looking up data by splitting according to 'binary' value

Threaded View

  1. #1
    Registered User
    Join Date
    04-19-2013
    Location
    Brunssum
    MS-Off Ver
    Excel 2003
    Posts
    17

    Question looking up data by splitting according to 'binary' value

    ORIGINAL QUESTION:
    Hello,

    I have a table like the following:
    Example:

    INDEX DATA
    1.....A
    2.....B
    4.....C
    8.....D
    16.....E
    32.....F
    64.....G
    128.....H

    The counting is just like binary. I want to fill a cell with data by looking up a value from a cell, 'splitting' it according to the table and filling another cell by adding the looked up values as text.
    So the value 3 corresponds to 'A B' (1 + 2). The value 57 corresponds with 'A D E F' (1 + 8 + 16 + 32).
    I have not been able to find how to do this since I have no clue what this kind of function is called in excel and haven't been able to find the using a search.
    Many thanks in advance for any help!


    Moderator's note: Original Discussion

    example file

    Many thanks in advance for any help!
    Last edited by JBeaucaire; 04-27-2013 at 06:17 PM.

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