Table lookup with multiple constraints

T

TechMGR

I have a fairly basic table of bolts and their attributes...

A B C
1 SIZE LENGTH STRENGTH
2 .5 1/2 100
3 .5 3/4 150
4 .75 1/2 150
5 .75 3/4 200

Cell D6 is an input cell for "size"
cell D7 is an input cell for "strength"
Cell D8 is the resultant lookup

I want to do a vlookup(?) that finds the correct length based upon BOTH size
(D6) AND strength (D7). "Size" will always find an exact match but
"strength" needs to be the first strength that is >= the input strength.

Any help is much appreciated.
S
 

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

Similar Threads

look up table values with multiple conditions 3
Table lookup using multiple qualifiers 1
VBA to copy from one workbook into another 0
List all tables, including document structure 0
Arriving at totals 2
VBA - (re-) Set a Table Style 2
Query that Selects all rows from one Table and Adds a Third Column 2
Simple Calculation Bug 1

Top