Hello, with Index and Match functions, how can I write a formula to give me the following output column? Excel sheet attached.
Input Input Output
Division City All Cities
Dhaka D1 D1, D2, D3, D4, D5
Rajshahi R1 R1, R2, R3, R4, R5, R6, R7
Chittagong C1 C1, C2, C3, C4, C5
Khulna K1 K1, K2, K3, K4, K5
Dhaka D2 D1, D2, D3, D4, D5
Chittagong C2 C1, C2, C3, C4, C5
Rajshahi R2 R1, R2, R3, R4, R5, R6, R7
Khulna K2 K1, K2, K3, K4, K5
Chittagong C3 C1, C2, C3, C4, C5
Khulna K3 K1, K2, K3, K4, K5
Dhaka D3 D1, D2, D3, D4, D5
Rajshahi R4 R1, R2, R3, R4, R5, R6, R7
Dhaka D4 D1, D2, D3, D4, D5
Rajshahi R5 R1, R2, R3, R4, R5, R6, R7
Rajshahi R6 R1, R2, R3, R4, R5, R6, R7
Chittagong C4 C1, C2, C3, C4, C5
Khulna K4 K1, K2, K3, K4, K5
Dhaka D5 D1, D2, D3, D4, D5
Rajshahi R7 R1, R2, R3, R4, R5, R6, R7
Chittagong C5 C1, C2, C3, C4, C5
Khulna K5 K1, K2, K3, K4, K5
Bookmarks