D
Dee
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.
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.