Results 1 to 5 of 5

Thread: Comparing numbers from one table to another

  1. #1

    Comparing numbers from one table to another



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    So i kinda suck at excel, only use it for time tables etc.

    But i really want to get this to work

    This is my problem, i have 3 tables.

    Table 1

    kolonne3 kolonne4 kolonne5 kolonne6
    1 0
    1 1
    1 8
    2 7
    2 4
    3 5
    4 6
    4 3
    5 2
    Table 2
    Kolonne1 Kolonne2
    1 1
    2 8
    3 27
    4 64
    5 125
    6 216
    7 343
    8 512
    9 729

    Table3

    Kolonne1 Kolonne2
    0 0
    1 1
    2 8
    3 7
    4 4
    5 5
    6 6
    7 3
    8 2
    9 9


    So, im going to try and explain what im having problems with.

    Problem 1:

    In Table 1, value for kolonne5,
    Needs to check (table 1 kolonne3) And compare it to (table2 kolonne2), and return the value from table2,kolonne1
    So any number from 1 and under 8 should return the value 1, any number from 8 and under 27 should return 2, and so forth

    Problem 2:

    in Table1, value for kolonne6
    Compare value from (table1,kolonne4) and (table3,kolonne2) and return value from (table3,kolonne1)


    I have tried a range of different formulaes, from vlookup, Index with match. but it only return errors for me.
    I hope anyone understood what im having trouble with, and I also hope anyone can solve it.

  2. #2
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    plz see the file.
    Attached Files Attached Files

  3. #3
    Thanks for replying to my question

    The solution for problem 1 did work but, i didnt copy the entire table into this thread, but i can expand it.

    For problem 2, it only returns errors.

    This is my file, if it helps
    Attached Files Attached Files

  4. #4
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Hi,
    Now check your file.
    Attached Files Attached Files

  5. #5
    Quote Originally Posted by sambit View Post
    Hi,
    Now check your file.
    Thank you so much

    Ill just expand the problem1 formula manualy

    Thanks!

    -roffern-

Posting Permissions

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