INDEX MATCH or VLOOKUP - Confused.

[mohdabrar]

Hi,

So, I have the data in the below format. The dates horizontally repeat 4 times and I need to get the week no. from the reference table which is in column V to Y. I think the amount of data shared should be enough to understand. It's a 4 week rotation, Week Starting from Monday to Sunday. I need to look up the date and get the week no from the reference table from columns V to Y in A2. Any help is appreciated. Thanks!

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	01/02/2022	01/02/2022	01/02/2022	01/02/2022	02/02/2022	02/02/2022	02/02/2022	02/02/2022	03/02/2022	03/02/2022	03/02/2022	03/02/2022	04/02/2022	04/02/2022	04/02/2022	04/02/2022	05/02/2022	05/02/2022	05/02/2022	05/02/2022		Date	Day	Month	Rotation Week
2																						01/02/2022	Tue	February	Week 1
3																						02/02/2022	Wed	February	Week 1
4																						03/02/2022	Thu	February	Week 1
5																						04/02/2022	Fri	February	Week 1
6																						05/02/2022	Sat	February	Week 1
Sheet1

Cell Formulas
Range	Formula
W2:W6	W2	=TEXT(V2,"DDD")
X2:X6	X2	=TEXT(V2,"MMMM")
V3:V6	V3	=V2+1

 

[bebo021999]

How about:
=VLOOKUP(A1,$V$2:$Y$6,4,0)

 

[mohdabrar]

How about:
=VLOOKUP(A1,$V$2:$Y$6,4,0)

Doesn't work since the date repeats 4 times from Column A to D.

 

[bebo021999]

I mean copy paste A2 to T2.
What your outcome look like? type it manually and post it again.

 

[mohdabrar]

I mean copy paste A2 to T2.
What your outcome look like? type it manually and post it again.

That actually worked. It was my excel sheet's problem, Auto cals were off. Thanks!