S
Simon
Column G contains numbers ranging from 10 to 60. I need to reference G
with another table to return data from that table.
e.g.
G3=36.3
L M N
3 10 8 2
4 15 12 4
5 20 17 5
6 25 21 6
7 30 25 7
8 35 29 9
9 40 33 10
G must be rounded down to the nearest number in L. I then need to
return the numbers in M and N from the same row.
i.e. G3=L7, returning M7 and N7.
I intend to use two cells for the M and N results.
Hope this is sufficient explaination for you. Thanks in anticipation.
Simon
with another table to return data from that table.
e.g.
G3=36.3
L M N
3 10 8 2
4 15 12 4
5 20 17 5
6 25 21 6
7 30 25 7
8 35 29 9
9 40 33 10
G must be rounded down to the nearest number in L. I then need to
return the numbers in M and N from the same row.
i.e. G3=L7, returning M7 and N7.
I intend to use two cells for the M and N results.
Hope this is sufficient explaination for you. Thanks in anticipation.
Simon