Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neil M
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Neil M
 
Posts: n/a
Default Not Sure if HLOOKUP, VLOOKUP or LISTLOOKUP..Help!


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




  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
lookup combine vlookup with hlookup Doug Excel Worksheet Functions 2 April 23rd 23 11:42 AM
How do I use Vlookup or Hlookup? exsam21 Excel Discussion (Misc queries) 2 September 23rd 05 07:26 PM
VLookup and HLookup at the same time Steven Excel Worksheet Functions 3 August 22nd 05 09:16 PM
Vlookup and Hlookup Phlogiston2312 Excel Worksheet Functions 1 April 21st 05 04:59 PM
Can vlookup or hlookup look to other worksheets within a workbook. flgc54 Excel Worksheet Functions 1 March 12th 05 01:31 AM


All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"