Excelhelpkar
New Member
- Joined
- Jan 21, 2014
- Messages
- 3
Help Please!!
It is looking at columns o-bn and is looking at the criteria below. IF the BW column contains an (in this case) E bring information in T3 column. How can I simplify this formula?
IF($O3=$BW$2,$P3,"")&IF($S3=$BW$2,$T3,"")&IF($W3=$BW$2,$X3,"")&IF($Z3=$BW$2,$AA3,"")&IF($AC3=$BW$2,$AD3,"")&IF($AF3=$BW$2,$AG3,"")&IF($AI3=$BW$2,$AJ3,"")&IF($AL3=$BW$2,$AM3,"")&IF($AO3=$BW$2,$AP3,"")&IF($AR3=$BW$2,$AS3,"")&IF($AU3=$BW$2,$AV3,"")&IF($AX3=$BW$2,$AY3,"")&IF($BA3=$BW$2,$BB3,"")&IF($BD3=$BW$2,$BE3,"")&IF($BG3=$BW$2,$BH3,"")
BW- Column
<!--StartFragment--> <colgroup><col width="92" style="width:92pt"> </colgroup><tbody>
<!--EndFragment--></tbody>
It is looking at columns o-bn and is looking at the criteria below. IF the BW column contains an (in this case) E bring information in T3 column. How can I simplify this formula?
IF($O3=$BW$2,$P3,"")&IF($S3=$BW$2,$T3,"")&IF($W3=$BW$2,$X3,"")&IF($Z3=$BW$2,$AA3,"")&IF($AC3=$BW$2,$AD3,"")&IF($AF3=$BW$2,$AG3,"")&IF($AI3=$BW$2,$AJ3,"")&IF($AL3=$BW$2,$AM3,"")&IF($AO3=$BW$2,$AP3,"")&IF($AR3=$BW$2,$AS3,"")&IF($AU3=$BW$2,$AV3,"")&IF($AX3=$BW$2,$AY3,"")&IF($BA3=$BW$2,$BB3,"")&IF($BD3=$BW$2,$BE3,"")&IF($BG3=$BW$2,$BH3,"")
BW- Column
Criteria |
C |
E |
L |
O |
P |
S |
<!--StartFragment--> <colgroup><col width="92" style="width:92pt"> </colgroup><tbody>
<!--EndFragment--></tbody>