hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,213
- Office Version
- 2010
- Platform
- Windows
- Mobile
My Data Range is B2:G9 (contains values) with ‘headers’ in B1:G1 (Non -numeric)
‘switches’ are in B12:G12 which are EITHER 0 OR 1; AND at a time ONLY 1 ‘SWITCH‘ FOR ‘UNIQUE’ HEADER WILL HAVE 0 OR 1
‘MATCHING SWITCH’ is in I1:L1
Output is required in I2:J9 as:
MATCH THE SWITCH & ‘grab’ the value from B2:G9
How to accomplish?
Thanks in advance.
I am using Excel 2007.
Sheet1
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 12px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"></colgroup><tbody>
</tbody>
‘switches’ are in B12:G12 which are EITHER 0 OR 1; AND at a time ONLY 1 ‘SWITCH‘ FOR ‘UNIQUE’ HEADER WILL HAVE 0 OR 1
‘MATCHING SWITCH’ is in I1:L1
Output is required in I2:J9 as:
MATCH THE SWITCH & ‘grab’ the value from B2:G9
How to accomplish?
Thanks in advance.
I am using Excel 2007.
Sheet1
B | C | D | E | F | G | H | I | J | |
1 | H | L | H | L | H | L | H | L | |
2 | 50 | 60 | 70 | 80 | 88 | 99 | 70 | 60 | |
3 | |||||||||
4 | |||||||||
5 | |||||||||
6 | |||||||||
7 | |||||||||
8 | |||||||||
9 | 1 | 2 | 5 | 8 | 9 | 1 | 5 | 2 | |
10 | |||||||||
11 | |||||||||
12 | 0 | 1 | 1 | 0 | 0 | 0 |
<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"><col style="WIDTH: 12px"><col style="WIDTH: 40px"><col style="WIDTH: 40px"></colgroup><tbody>
</tbody>