Thread: picking up figures

I think this is what you need

For Displacement

=INDEX(Data!$B$2:$B$5,MATCH(ROUND(B9,1),Data!$A$2:$A$5,0))

Jebo,

Welcome to the forum.

Please take a few minutes to read the Forum Rules about thread titles carefully before starting your next thread.

Originally Posted by sglife

I think this is what you need

For Displacement

=INDEX(Data!$B$2:$B$5,MATCH(ROUND(B9,1),Data!$A$2:$A$5,0))

Thx for the reply, and tried that formula, but it only gives the figures for 3.2m and not the 3.3m figure that i also need, becoz i have to calculate the 3.24625m.

This is what i want excel to do :

My job is to calculate how much a sea vessel loads/discharge.
So i created this file sofar, it calculates it with no errors.
Now i want to make it myself easier, and added a Data tab, where i can fillin all the figures i need to make those calculations.

Here is my question:

How can i get excel to see on the calculation tab, the figure thats in cell B9 and B16, to get the values out of the data tab, and use it in the above empty cells, so it can calculate them.

Also the number thats in cell B9 is in meters, so excel should get inside the data figures, the closest above that number, and closest below that number, and continue gettin all the other cells to use.

Here is the file : http://jebo65.com/images/example-DSReport.xlsm

i cant figure out how i can excel to get the data out of the data tab.

and if like in the example, the draft is found at 3.24625, how do you get excel to take the figures, 1x at 3.3m and 1x at 3.2m so the program can calculate what the value will be for 3.24625.


I updated the file from first post, so u get a better view of what i'm searching for.
The numbers are put in manualy now, but i want it automated.
Hopefully one of the Excel Guru's here can help me out.