I'm trying to replace a dropdown menu, whith a cell. The user is going to input the real distance in this cell.
As it's works now, the user select the nearest "visible" distant (there can be several selectables but the one whith the best / longest option is visible)
So this works like this. There are several tabels, I use INDEX to select speed and angle. This is presented in one tab (picture)
I then select the secondary angle (B to I column) presented in L column
The M column have some IF to present tre result in the drop down.
This works good. But now I some how want to put a real measure in a cell and some kind of formula look at the cell and then see the selected tabel values to se the nearest lower value
Any suggestions?
As it's works now, the user select the nearest "visible" distant (there can be several selectables but the one whith the best / longest option is visible)
So this works like this. There are several tabels, I use INDEX to select speed and angle. This is presented in one tab (picture)
I then select the secondary angle (B to I column) presented in L column
The M column have some IF to present tre result in the drop down.
This works good. But now I some how want to put a real measure in a cell and some kind of formula look at the cell and then see the selected tabel values to se the nearest lower value
Any suggestions?
