Finding the quarter of the year according to a campaign number

[domanteb]

Hey guys!
I am doing an assignment and I have troubles with one of the questions.
The question is asking to use this table: https://imgur.com/7JjrQ5H
And then to find which quarter matches the campaign number, using a formula
https://imgur.com/ZDUCN0b

I have tried to make a new table and use vlookup but it does not seem to work.
How could I fill in the quarters using the table provided that contains the ranges?

Thank you so much in adcance!

 

[Nishant94]

Assuming you have Qtr table as this:

Unknown
	B	C	D
14	Qtr	Campaign
15		From	To.
16	Q1	1	4
17	Q2	5	9
18	Q3	10	13
19	Q4	14	17
Sheet9

Then You can use this:

Unknown
	A	B	C	D	E	F	G	H	I
1	Campaign	Acc No.	Sales	Orders	Customers	Zone	Year	Campaign of the year	Qtr
2	2015-14	7004340	2	2	9	502	2015	2	Q1
3	2015-14	7004396	8	1	8	503	2015	14	Q4
4	2015-14	7004351	6	0	13	502	2015	11	Q3
5	2015-14	7004322	10	4	2	505	2015	11	Q3
6	2015-14	7004399	5	0	9	507	2015	7	Q2
7	2015-14	7004332	6	4	7	510	2015	3	Q1
8	2015-14	7004394	9	0	3	507	2015	15	Q4
9	2015-14	7004365	3	3	12	508	2015	12	Q3
10	2015-14	7004392	9	2	8	504	2015	15	Q4
11	2015-14	7004363	8	4	6	506	2015	3	Q1
Sheet9

Cell Formulas
Range	Formula
I2	{=INDEX($B$16:$B$19,MATCH(1,(H2>=$C$16:$C$19)*(H2<=$D$16:$D$19),0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Nishant94]

Or You can use

Assuming you have Qtr table as this:

Unknown
	B	C	D
14	Qtr	Campaign
15		From	To.
16	Q1	1	4
17	Q2	5	9
18	Q3	10	13
19	Q4	14	17
Sheet9

Then You can use this:

Unknown
	A	B	C	D	E	F	G	H	I
1	Campaign	Acc No.	Sales	Orders	Customers	Zone	Year	Campaign of the year	Qtr
2	2015-14	7004340	2	2	9	502	2015	2	Q1
3	2015-14	7004396	8	1	8	503	2015	14	Q4
4	2015-14	7004351	6	0	13	502	2015	11	Q3
5	2015-14	7004322	10	4	2	505	2015	11	Q3
6	2015-14	7004399	5	0	9	507	2015	7	Q2
7	2015-14	7004332	6	4	7	510	2015	3	Q1
8	2015-14	7004394	9	0	3	507	2015	15	Q4
9	2015-14	7004365	3	3	12	508	2015	12	Q3
10	2015-14	7004392	9	2	8	504	2015	15	Q4
11	2015-14	7004363	8	4	6	506	2015	3	Q1
Sheet9

Cell Formulas
Range	Formula
I2	=LOOKUP(H2,$C$16:$C$19,$B$16:$B$19)