# Thread: Comparing numbers from one table to another

1. ## Comparing numbers from one table to another

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. Hi,
plz see the file.

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

4. Hi,

5. Originally Posted by sambit
Hi,
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
•