UrbanJungleFashion
New Member
- Joined
- Oct 14, 2014
- Messages
- 17
Hello All.
I can't for the life of me figure out how to do an index array. I have been all over YouTube and Chandoo and I can't figure it out and I have a very simple one.
In column B3 I want to enter the Region name in and in rows B8-B22 list the stores that fall under that region.
I tried to use the formula:
=INDEX($D$2:$D$27,SMALL(IF($E$2:$E$27=$B$3,ROW($E$2:$E$27)-ROW($E$2)+1),ROWS($B$8:B8)),"")
But that's not working correctly.
Can someone tell me what the correct formula should be and where I'm going wrong?
Example:
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>
I can't for the life of me figure out how to do an index array. I have been all over YouTube and Chandoo and I can't figure it out and I have a very simple one.
In column B3 I want to enter the Region name in and in rows B8-B22 list the stores that fall under that region.
I tried to use the formula:
=INDEX($D$2:$D$27,SMALL(IF($E$2:$E$27=$B$3,ROW($E$2:$E$27)-ROW($E$2)+1),ROWS($B$8:B8)),"")
But that's not working correctly.
Can someone tell me what the correct formula should be and where I'm going wrong?
Example:
A | B | C Store | D Region | |
0004 | 212 | |||
212 | 0008 | 212 | ||
0012 | 212 | |||
0016 | 212 | |||
0020 | 212 | |||
STORES | 0024 | 212 | ||
1 | #VALUE! | 0003 | 445 | |
2 | #NUM! | 0007 | 445 | |
3 | #NUM! | 0011 | 445 | |
4 | #NUM! | 0015 | 445 | |
5 | #NUM! | 0019 | 445 | |
6 | #NUM! | 0023 | 445 | |
7 | #NUM! | 0002 | 451 | |
8 | #NUM! | 0006 | 451 | |
9 | #NUM! | 0010 | 451 | |
10 | #NUM! | 0014 | 451 | |
11 | #NUM! | 0018 | 451 | |
12 | #NUM! | 0022 | 451 | |
13 | #NUM! | 0026 | 451 | |
14 | #NUM! | 0001 | 551 | |
15 | #NUM! | 0005 | 551 | |
0009 | 551 | |||
0013 | 551 | |||
0017 | 551 | |||
0021 | 551 | |||
0025 | 551 |
<colgroup><col><col><col span="3"></colgroup><tbody>
</tbody>