If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Lookup value on a table??
I have the following table below. If I place in cell "A100" the figure -7 and
in cell "A101" the figure -975. What formula do I need to put in cell "102" the result, in this case it would be 787. Also on column "A" if the figure is between two (ie -960) it should use the row with the highier value, in this case the result would still be 787. A B C D E F 1 -10 -9 -8 -7 -6 2 -1000 790 790 788 786 784 3 -975 791 791 789 787 785 4 -950 791 791 789 787 785 5 -925 792 792 790 788 786 6 -900 793 793 791 789 787 7 -875 793 793 791 789 787 8 -850 794 794 792 790 788 9 -825 794 794 792 790 788 10 -800 795 795 793 791 789 |
Thread Tools | |
Display Modes | |
|
|