I need to lookup values in column K based on column P being yes, and description in A1. I was going to do a helper column, but seems alot of extra for nothing. I dont want to use a if statement because as I develop this, column P could get to 15-20 choices.
Bolted Wood Connection.xlsm | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |||
1 | Select Structural | |||||||||||||||||
2 | Dense Select Structural | 10" wide | 1950 | 1300 | 175 | 660 | 1800 | 1900000 | 690000 | 0.55 | no | |||||||
3 | Select Structural | 1700 | 1150 | 175 | 565 | 1650 | 1800000 | 660000 | ||||||||||
4 | Non-Dense Select Structural | 1500 | 1050 | 175 | 480 | 1600 | 1600000 | 580000 | ||||||||||
5 | No.1 Dense | 1200 | 800 | 175 | 660 | 1550 | 1800000 | 660000 | ||||||||||
6 | No.1 | 1050 | 700 | 175 | 565 | 1450 | 1600000 | 580000 | ||||||||||
7 | No.1 Non-Dense | 950 | 625 | 175 | 480 | 1400 | 1400000 | 510000 | ||||||||||
8 | No.2 Dense | 850 | 525 | 175 | 660 | 1350 | 1600000 | 580000 | ||||||||||
9 | No.2 | 800 | 475 | 175 | 565 | 1300 | 1400000 | 510000 | ||||||||||
10 | No.2 Non-Dense | 750 | 425 | 175 | 480 | 1250 | 1300000 | 470000 | ||||||||||
11 | No.3 and Stud | 475 | 275 | 175 | 565 | 750 | 1300000 | 470000 | ||||||||||
12 | Dense Select Structural | 12" wide | 1800 | 1250 | 175 | 660 | 1750 | 1900000 | 690000 | 0.55 | Yes | |||||||
13 | Select Structural | 1600 | 1100 | 175 | 565 | 1650 | 1800000 | 660000 | ||||||||||
14 | Non-Dense Select Structural | 1400 | 975 | 175 | 480 | 1550 | 1600000 | 580000 | ||||||||||
15 | No.1 Dense | 1100 | 750 | 175 | 660 | 1500 | 1800000 | 660000 | ||||||||||
16 | No.1 | 1000 | 650 | 175 | 565 | 1400 | 1600000 | 580000 | ||||||||||
17 | No.1 Non-Dense | 900 | 575 | 175 | 480 | 1350 | 1400000 | 510000 | ||||||||||
18 | No.2 Dense | 800 | 500 | 175 | 660 | 1300 | 1600000 | 580000 | ||||||||||
19 | No.2 | 750 | 450 | 175 | 565 | 1250 | 1400000 | 510000 | ||||||||||
20 | No.2 Non-Dense | 700 | 400 | 175 | 480 | 1250 | 1300000 | 470000 | ||||||||||
21 | No.3 and Stud | 450 | 250 | 175 | 565 | 725 | 1300000 | 470000 | ||||||||||
Sheet4 |