James Coats

asked on

# Excel Select Box IF statement question

On excel sheet "LVL Test Data pg 1" cells J8, K8 & L8 are sample test times.

If an "X" is in cells J9, K9 or L9 (only one cell can have an "X") it needs to reference excel sheet "Patterns" rows: E thru M

"Patterns" Excel Sheet Name Relation on Excel Sheet "LVL Test Data pg 1"

Columns Test name

E EdgeBend Edge Bending A6

F FlatBend Flat Bending C6

G Tension Tension D6

H MC Moisture Content E6

I GlueBond Glue Bond Durability G6

J ABond A Bond Durability I6

K 10H2 10" H2 Specimen K6

There is a numerical code in the columns listed above associated with each pattern in row A they are:

0 = Never

1 = 24 hr, Start Up or C/O

2 = Always

If the thickness in row "D" "SpecBilletThick" on patterns is greater than "1.75" then a Tension test is not needed from row "G" from sheet "Patterns"

Based on whether there is a 0, 1 or 2 in the rows E thru M in excel sheet "Patterns"

an " X " needs to appear in excel sheet "LVL Test Data pg 1"

In cells A7, C7, D7, E7, G7, I7 or K7 in their name relation under the cell above.

Password to view VBA code is: tyrannis

LVLDataSheetsAutoPWCLocking.xlsm

If an "X" is in cells J9, K9 or L9 (only one cell can have an "X") it needs to reference excel sheet "Patterns" rows: E thru M

"Patterns" Excel Sheet Name Relation on Excel Sheet "LVL Test Data pg 1"

Columns Test name

E EdgeBend Edge Bending A6

F FlatBend Flat Bending C6

G Tension Tension D6

H MC Moisture Content E6

I GlueBond Glue Bond Durability G6

J ABond A Bond Durability I6

K 10H2 10" H2 Specimen K6

There is a numerical code in the columns listed above associated with each pattern in row A they are:

0 = Never

1 = 24 hr, Start Up or C/O

2 = Always

If the thickness in row "D" "SpecBilletThick" on patterns is greater than "1.75" then a Tension test is not needed from row "G" from sheet "Patterns"

Based on whether there is a 0, 1 or 2 in the rows E thru M in excel sheet "Patterns"

an " X " needs to appear in excel sheet "LVL Test Data pg 1"

In cells A7, C7, D7, E7, G7, I7 or K7 in their name relation under the cell above.

Password to view VBA code is: tyrannis

LVLDataSheetsAutoPWCLocking.xlsm

ASKER

A human will determine when an X is placed in one of the boxes based on what test is being performed. Only one test is performed per event. So if an X appears in any one of the three boxes the others have to auto populate per the values in the sheet patterns.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

An X is only placed in the cells: J9, K9 or L9. Only one of these cells can contain an X.

If the thickness in "Spec. Thickness" (J4) is greater than 1.75 no value needs to populate D7 under Tension.

OK based on pattern 5004: If any one of the cells J9, K9 or L9 had an X. An X should appear in cells: C7, E7, G7, and I7

Based on pattern 7001: If any one of the cells J9, K9 or L9 had an X. An X should appear in cells: C7, D7, E7, G7 and A9.

Based on pattern 26000: If any one of the cells J9, K9 or L9 had an X. An X should appear in cells: C7, D7, E7, G7 and D9.

Based on pattern 24316H: If any one of the cells J9, K9 or L9 had an X. An X should appear in cells: C7, D7, E7, G7, I7 and K7

Does this help?

If the thickness in "Spec. Thickness" (J4) is greater than 1.75 no value needs to populate D7 under Tension.

OK based on pattern 5004: If any one of the cells J9, K9 or L9 had an X. An X should appear in cells: C7, E7, G7, and I7

Based on pattern 7001: If any one of the cells J9, K9 or L9 had an X. An X should appear in cells: C7, D7, E7, G7 and A9.

Based on pattern 26000: If any one of the cells J9, K9 or L9 had an X. An X should appear in cells: C7, D7, E7, G7 and D9.

Based on pattern 24316H: If any one of the cells J9, K9 or L9 had an X. An X should appear in cells: C7, D7, E7, G7, I7 and K7

Does this help?

ASKER

I will try the lookup and if I can't make it work I'll post back. Thank you for the suggestion.

"Based on whether there is a 0, 1 or 2 in the rows E thru M in excel sheet "Patterns"

an " X " needs to appear in excel sheet "LVL Test Data pg 1"

what determines if a X is placed ? always if 2, or if 1 and the code in J9-L9 matches ?

have you tried VLOOKUP ?