Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not Sure if HLOOKUP, VLOOKUP or LISTLOOKUP..Help!
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not Sure if HLOOKUP, VLOOKUP or LISTLOOKUP..Help!
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not Sure if HLOOKUP, VLOOKUP or LISTLOOKUP..Help!
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 "Neil M" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup combine vlookup with hlookup | Excel Worksheet Functions | |||
How do I use Vlookup or Hlookup? | Excel Discussion (Misc queries) | |||
VLookup and HLookup at the same time | Excel Worksheet Functions | |||
Vlookup and Hlookup | Excel Worksheet Functions | |||
Can vlookup or hlookup look to other worksheets within a workbook. | Excel Worksheet Functions |