|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
Nesting more than 7 IF statements (Excel 2003)
Dee wrote:
I have an inventory worksheet with many rows, where column D is a manual
entry of item length, column E is a manual entry of item width, and column G
is the weight of that size item. The weights for each inventory item are
stored in a table on a separate worksheet, with column A listing lenghts and
row 3 listing the widths. Since IF statements are limited to 7, how else can
I have column G automatically populated with the correct weight, based on
what is manually entered in columns D & E? ie: If length (col D) is 8, and
width (col E) is 2, then go look at the table and return the value at the
intersection of length 8 and width 2. I would then need to copy that formula
all the way down my inventory sheet.
http://www.contextures.com/xlFunctio...ml#IndexMatch2
|