C
Code Numpty
I have a table of data where the first column is a machine capacity and the
other columns contain force figures
50 0.1 0.2 0.5 1 2 5 10 15 20 30 40 50
100 2 5 10 20 30 40 60 80 100
1500 100 200 300 600 900 1200 1500
In a simple version the capacity is in cell C16 and cells D1629 use a
VLOOKUP formula to reference the table and display a list of force figures
based on C16.
So if C16 = 50 D1629 returns the following
0.1
0.2
0.5
1
2
5
10
15
20
30
40
50
0
0
However I now have maximum & minimum values specified as below example.
A 0.1 2
B 2 15
C 15 50
What I need to do is return forces within the maximum and minimum figures,
including the overlap.
So if C16 = 50
D1629 needs to return the following (note 2 instances of 2 and 15).
0.1
0.2
0.5
1
2
2
5
10
15
15
20
30
40
50
I need this to work on the first simple basis and also on the basis of 2 or
3 sets of maximum & minimum figures.
I do hope this makes sense and would be grateful for any help with this,
thanks.
other columns contain force figures
50 0.1 0.2 0.5 1 2 5 10 15 20 30 40 50
100 2 5 10 20 30 40 60 80 100
1500 100 200 300 600 900 1200 1500
In a simple version the capacity is in cell C16 and cells D1629 use a
VLOOKUP formula to reference the table and display a list of force figures
based on C16.
So if C16 = 50 D1629 returns the following
0.1
0.2
0.5
1
2
5
10
15
20
30
40
50
0
0
However I now have maximum & minimum values specified as below example.
A 0.1 2
B 2 15
C 15 50
What I need to do is return forces within the maximum and minimum figures,
including the overlap.
So if C16 = 50
D1629 needs to return the following (note 2 instances of 2 and 15).
0.1
0.2
0.5
1
2
2
5
10
15
15
20
30
40
50
I need this to work on the first simple basis and also on the basis of 2 or
3 sets of maximum & minimum figures.
I do hope this makes sense and would be grateful for any help with this,
thanks.