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). I am sure there is a way to do this but I am used to
only having one variable to do the vlookup with.

=vlookup(D6, A1:C5, 2) where the result is =D7 (How do I do this?)