Matching a result to a certain value from a STAS table values

[andreiscreciu]

I need to round a calculated value to the nearest value contained in a STAS table.
For better understanding, this are the specific values:

STAS table value:
0,102; 0,120; 0,145; 0,167; 0,182 ;
0,210; 0,245; 0,280;
0,327; 0,380;
0,423;
0,560;
0,650;
0,740;
0,850;
0,990;

My result is 0.381.

So i need to continue the calculations with the nearest STAS value, witch is 0.380.

Thanks!

[Harribone]

See attached file.

The STAS values are on a seperate sheet.
The Results sheet is where you eneter your value and the the cell to the right will find the STAS value to use for your calculations.

Just be aware that if you add any values to the STAS list you need to sort from smallest to largest to ensure that this works correctly.


STAS.xlsx

[andreiscreciu]

Thank you very much!
I am curious... is there a way to do this with the table values in a row?

[Harribone]

If you change the VLOOKUP to HLOOKUP this will work for a row. The STAS!A:A needs changing to STAS!1:1 to tell excel the data to look at is in row 1

[andreiscreciu]

Thank you!