Not Sure if HLOOKUP, VLOOKUP or LISTLOOKUP..Help!

[Neil M]

I have a spread sheet that has the following cells:

A1 is a material dd list of slings (rope, wire rope, synthetic web)
B2 is a material type - if rope is selected in A1 then in B2 you only get
types of rope, if wire rope is selected, you only get types of wire rope, etc
etc.

Now here is the problem I can't solve. Rope comes in different sizes from
3/16" to 4" and has different weights in lbs/ft. which I have listed in a
table.

The problem I am having is that you are only allowed so many arguments in an
"=IF" function and I have more types of slings than allowed to use a VLOOKUP
for each one.

A1 and B2 are validated lists using an indirect function.

I want to now to be able to say select rope in A1 then nylon rope in B2
furthermore, in C2 I want to be able to select say 3/4" rope and have the
lbs/ft for that specific type appear in D2.

Would a list lookup work here or is there a way to make an indirect work. I
have the different types in a table with the type of material as column
headers, the sizes from 3/16 to 4 in a far left vertical column, the
corresponding weights are horizontally arranged under the proper type.
37 cells across, 44 cells down

 

[Neil M]

PS: I would be more than happy to email the spreadsheet for anyone who wants
to try and tackle this or needs more info.

(e-mail address removed)

 

[Biff]

Hi!

You need another cell where you select the size, then, either a
Vlookup/Match or an Index/Match should work.

I'll send you an email so I can take a look at your file.

Biff