Conditional VLOOKUP

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 D16:D29 use a
VLOOKUP formula to reference the table and display a list of force figures
based on C16.

So if C16 = 50 D16:D29 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
D16:D29 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top