Spreadsheet: 128664d1321171528-help-with-combination-of-if-and-vlookup-formula-test-example-sept-2011
Sheet: Data

Product | Bar | BSM | BSP | Buttweld | Flanges | Flat | Tubular | Tube_Fittings |  | SCHEDULE | Flat Fin | Tube Fin | Bar | Grade | Weight | UOM | Enquiry |  |  | Weight factor | Product weight formula
Bar | Flat Bar | Blank Caps | Round Socket | 90D Elbows | Table D SOW Tube | [NAME] | AW Tube | 45D Bend |  | 10S | No1 | MF | SRE | 201 | 8 | [NAME] | Additional |  |  | 8 | #N/A |  | Round | #N/A
BSM | Round Bar | Blank Nuts | Nipple TBE | 45D Elbows | Table E SOW Tube | [NAME] | AWA Tube | 90D Bend |  | 40S | 2E | 180G | HRAP | 303 | 8.177 | Eaches | revised |  |  | 8.177 | #N/A |  | Square & RHS | #N/A
BSP | [NAME] | Hex Nut | Nipple TOE | Tees | Table D SOW Pipe | [NAME] | CWA Tube | 180D Bend |  | 80S | 2D | 320G | CD | 304 | 8.177 | Lengths | New |  |  | 8.177 | #N/A |  | Sheet | 713.2612800000002
Buttweld | Square Bar | Liner CIP | Hex Round Cap | Con Reducer | Table E SOW Pipe | Sheet | AS1528 Tube | Tee |  |  | 2B | 400G |  | 304L | 8.177 | Tonnes | Updated |  |  | 8.177 | #N/A
Flanges | Hex Bar | Liner CIPFF | 3 Piece Union | Ecc Reducer | Table D Blind Tube | Sheet Blanks | SMLS Tube | Red Tee |  |  | N4 | 600G |  | 304/304L | 8.177 | Sheets |  |  |  | 8 | #N/A |  | Sheet Formula | Length (offer E4) x [NAME] (offerGI4) x thickness (offer I4) x grade weight factor (data U2) x quantity (offer K4)
Flat | Channel | Liner RJT | FF 90D Elbow | End Cap | Table E Blind Tube | Plate | Spiral Wld Tube | Con Reducer |  |  | N5 | 800G |  | 316 | 8.177 |  |  |  |  | #N/A | #N/A
Tubular | Hollow Bar | Male Part CIP | FF Tee | Stub End | Table D Blind Pipe | Chequer Plate | Square Tube | Ecc Reducer |  |  | N8 | 1200G |  | 316L | 8.177 |  |  |  |  | #N/A | #N/A
Tube_Fittings | SS Wire | Male Part CIPFF | Hex Plug | Red Tee | Table E Blind Pipe | Cut Plate | Rect Tube | Plain Clamps |  |  |  |  |  | 316/316L | 8.177 |  |  |  |  | #N/A | #N/A
 | Spring Wire | Male Part RJT | Hex Red Bush |  | SORF 150# | [NAME] | Single Slot Tube | Adj Foot |  |  |  |  |  | 431 | 8 |  |  |  |  | #N/A | #N/A
 | [NAME] | O Ring CIP | Hex Red Nipple |  | SORF 300# | [NAME] | Double Slot Tube | Plastic Insert |  |  |  |  |  | 430 | 8 |  |  |  |  | #N/A | #N/A
 | Weaving wire | O Ring RJT | Hex Locknut |  | SORF 600# |  | Welded Pipe |  |  |  |  |  |  | 444 | 8 |  |  |  |  | #N/A
 | Flattened Wire |  | MF 90D Elbow |  | Blind RF 150# |  | Seamless Pipe |  |  |  |  |  |  | 310 | 8.177 |  |  |  |  | #N/A
 | Forged Bar |  | SW Cap 3000# |  | Blind RF 300# |  |  |  |  |  |  |  |  | 321 | 8.177 |  |  |  |  | #N/A
 |  |  | SW Coupling 3000# |  | Blind RF 600# |  |  |  |  |  |  |  |  | 409L | 8 |  |  |  |  | #N/A
 |  |  | SW 45D Elb 3000# |  | WNRF 150# |  |  |  |  |  |  |  |  | 410WMT | 8 |  |  |  |  | #N/A
 |  |  | SW 90D Elb 3000# |  | WNRF 300# |  |  |  |  |  |  |  |  | LDX2101 | 8
 |  |  | SW Tee 3000# |  | WNRF 600# |  |  |  |  |  |  |  |  | 2205 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 253MA | 8.177
 | Bar_Spec |  | BSP_Spec | BW-Spec | Flanges-Spec | Flat-Spec | Tube_Spec |  |  | Pipe_Spec |  |  |  | 3CR12 | 8
 | A276 |  | [NAME] / BS21 | A403M | AS2129 | A240M / 480 | AS1528 |  |  | A312M |  |  |  | 2507 | 8.177
 | A484 |  | A182M | A815M | A182M | A793 | A554 |  |  | A358 |  |  |  | 904L | 8.177
 | A582 |  |  |  |  |  | A269 |  |  | A790 |  |  |  | 404 GP | 8
 | A314 |  |  |  |  |  | A268 |  |  | A403
 |  |  |  |  |  |  | A249
 |  |  |  |  |  |  | A778
 |  |  |  | Dim A | [NAME] | Dim C
713.2612800000002 | Flat Bar | A276 / 484M |  | WIDTH | LEN. | THK. | TN | MT
 | Round Bar | A276 / 484M |  | DIA | LEN. | - | TN | MT
 | [NAME] | A276 / 484M |  | WIDTH | WIDTH | THK. | TN | MT
 | Square Bar | A276 / 484M |  | WIDTH | WIDTH | - | TN | MT
 | Hex Bar | A276 / 484M |  | WIDTH | LEN. | - | TN | MT
 | Channel | A276 / 484M |  | FLANGE | WEB | THK. | TN | MT
 | Hollow Bar | A511 / 484M |  | OD | ID | - | TN | MT
 | SS Wire |  |  | DIA | - | - | TN | TN
 | Spring Wire |  |  | DIA | - | - | TN | TN
 | [NAME] |  |  | DIA | - | - | TN | TN
 | Weaving wire |  |  |  |  | - | TN | TN
 | Flattened Wire |  |  |  |  | - | TN | TN
 | Forged Bar |  |  | DIA | - | - | TN | MT
 | Round Socket | [NAME] / BS21 |  | MM | - | - | EA | EA
 | Nipple TBE | [NAME] / BS21 |  | MM | - | - | EA | EA
 | Nipple TOE | [NAME] / BS21 |  | MM | - | - | EA | EA
 | Hex Round Cap | [NAME] / BS21 |  | MM | - | - | EA | EA
 | 3 Piece Union | [NAME] / BS21 |  | MM | - | - | EA | EA
 | FF 90D Elbow | [NAME] / BS21 |  | MM | - | - | EA | EA
 | FF Tee | [NAME] / BS21 |  | MM | - | - | EA | EA
 | Hex Plug | [NAME] / BS21 |  | MM | - | - | EA | EA
 | Hex Red Bush | [NAME] / BS21 |  | MM | MM | - | EA | EA
 | Hex Red Nipple | [NAME] / BS21 |  | MM | MM | - | EA | EA
 | Hex Locknut | [NAME] / BS21 |  | MM | - | - | EA | EA
 | MF 90D Elbow | [NAME] / BS21 |  | MM | - | - | EA | EA
 | SW Cap 3000# | A182M |  | NB | - | - | EA | EA
 | SW Coupling 3000# | A182M |  | NB | - | - | EA | EA
 | SW 45D Elb 3000# | A182M |  | NB | - | - | EA | EA
 | SW 90D Elb 3000# | A182M |  | NB | - | - | EA | EA
 | SW Tee 3000# | A182M |  | NB | - | - | EA | EA
 | 90D Elbows | A403M |  | NB | - | SCH | EA | EA
 | 45D Elbows | A403M | A815M | NB | - | SCH | EA | EA
 | Tees | A403M | A815M | NB | - | SCH | EA | EA
 | Con Reducer | A403M | A815M | NB | - | SCH | EA | EA
 | Ecc Reducer | A403M | A815M | NB | - | SCH | EA | EA
 | End Cap | A403M | A815M | NB | - | SCH | EA | EA
 | Stub End | A403M | A815M | NB | - | SCH | EA | EA
 | Red Tee | A403M | A815M | NB | - | SCH | EA | EA
 | Table D SOW Tube | AS2129 | A182M | ID | - | - | EA | EA
 | Table E SOW Tube | AS2129 | A182M | ID | - | - | EA | EA
 | Table D SOW Pipe | AS2129 | A182M | ID | - | - | EA | EA
 | Table E SOW Pipe | AS2129 | A182M | ID | - | - | EA | EA
 | Table D Blind Tube | AS2129 | A182M | ID | - | - | EA | EA
 | Table E Blind Tube | AS2129 | A182M | ID | - | - | EA | EA
 | Table D Blind Pipe | AS2129 | A182M | NB | - | - | EA | EA
 | Table E Blind Pipe | AS2129 | A182M | NB | - | - | EA | EA
 | SORF 150# | A182M |  | NB | - | - | EA | EA
 | SORF 300# | A182M |  | NB | - | - | EA | EA
 | SORF 600# | A182M |  | NB | - | - | EA | EA
 | Blind RF 150# | A182M |  | NB | - | - | EA | EA
 | Blind RF 300# | A182M |  | NB | - | - | EA | EA
 | Blind RF 600# | A182M |  | NB | - | - | EA | EA
 | WNRF 150# | A182M |  | NB | - | - | EA | EA
 | WNRF 300# | A182M |  | NB | - | - | EA | EA
 | WNRF 600# | A182M |  | NB | - | - | EA | EA
 | [NAME] | A240M / 480 |  | WIDTH | - | - | TN | TN
 | [NAME] | A240M / 480 |  | WIDTH | - | - | TN | TN
 | [NAME] | A240M / 480 |  | WIDTH | - | - | TN | TN
 | Sheet | A240M / 480 |  | WIDTH | LEN. | THK. | TN | EA
 | Sheet Blanks | A240M / 480 |  | WIDTH | LEN. | THK. | TN | EA
 | Plate | A240M / 480 |  | WIDTH | LEN. | THK. | TN | EA
 | Chequer Plate | A793 |  | WIDTH | LEN. | THK. | TN | EA
 | Cut Plate | A240M / 480 |  | WIDTH | LEN. | THK. | TN | EA
 | [NAME] | A240M / 480 |  | WIDTH | LEN. | THK. | TN | TN
 | [NAME] | A240M / 480 |  | WIDTH | LEN. | THK. | EA | EA
 | AW Tube | A554 |  | O.D. | LEN. | W.T. | MT | MT
 | AWA Tube | A269 |  | O.D. | LEN. | W.T. | MT | MT
 | CWA Tube | A249 |  | O.D. | LEN. | W.T. | MT | MT
 | AS1528 Tube | AS1528 |  | O.D. | LEN. | W.T. | MT | MT
 | SMLS Tube | A269 |  | O.D. | LEN. | W.T. | MT | MT
 | Spiral Wld Tube | A778 |  | O.D. | LEN. | W.T. | MT | MT
 | Square Tube | A554 |  | O.D. | LEN. | W.T. | MT | MT
 | Rect Tube | A554 |  | O.D. | LEN. | W.T. | MT | MT
 | Single Slot Tube | A554 |  | O.D. | LEN. | W.T. | MT | MT
 | Double Slot Tube | A554 |  | O.D. | LEN. | W.T. | MT | MT
 | Welded Pipe | A312M |  | NB | LEN. | SCH | MT | MT
 | Seamless Pipe | A312M |  | NB | LEN. | SCH | MT | MT
 | Blank Caps | - |  | MM | - | - | EA | EA
 | Blank Nuts | - |  | MM | - | - | EA | EA
 | Hex Nut | - |  | MM | - | - | EA | EA
 | Liner CIP | - |  | MM | - | - | EA | EA
 | Liner CIPFF | - |  | MM | - | - | EA | EA
 | Liner RJT | - |  | MM | - | - | EA | EA
 | Male Part CIP | - |  | MM | - | - | EA | EA
 | Male Part CIPFF | - |  | MM | - | - | EA | EA
 | Male Part RJT | - |  | MM | - | - | EA | EA
 | O Ring CIP | - |  | MM | - | - | EA | EA
 | O Ring RJT | - |  | MM | - | - | EA | EA
 | 45D Bend | - |  | O.D. | - | W.T | EA | EA
 | 90D Bend | - |  | O.D. | - | W.T | EA | EA
 | 180D Bend | - |  | O.D. | - | W.T | EA | EA
 | Tee | - |  | O.D. | - | W.T | EA | EA
 | Red Tee | - |  | O.D. | - | W.T | EA | EA
 | Con Reducer | - |  | O.D. | - | W.T | EA | EA
 | Ecc Reducer | - |  | O.D. | - | W.T | EA | EA
 | Plain Clamps | - |  | O.D. | - | W.T | EA | EA
 | Adj Foot | - |  | O.D. | - | - | EA | EA
 | Plastic Insert | - |  | O.D. | - | - | EA | EA