Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2004
    Posts
    14

    Unanswered: Matrix searching

    A B C D
    1 RED BLUE GREEN ORANGE
    2 YELLOW PURPLE INDIGO WHITE
    3 BLACK LIME SILVER GOLD


    If I have the above matrix, what is the best way to do a 2 value lookup. For example, if someone chooses 2 and B, their color would be Purple. How would I search based on two different inputs to come up with one answer?

  2. #2
    Join Date
    Sep 2004
    Posts
    14
    Oops, that didn't come out right. I attached a file instead.
    Attached Files Attached Files

  3. #3
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    There are many ways, but I have suggested 2 in the attached.

    I assume that is what you had in mind!

    MTB
    Attached Files Attached Files

  4. #4
    Join Date
    Sep 2004
    Posts
    14
    Thank you. Very helpful.

  5. #5
    Join Date
    Sep 2004
    Posts
    14
    Thank you. Very helpful.

Posting Permissions

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