VLOOKUP AND RETURN MULTIPLE VALUES VERTICALLY

[nikhil0311]

Column B & C we have the raw data

in Column F we want the final output based on column E

				Output
Country	Item		Lookup value:	Results
Monday	Pipe		Monday	Pipe
Monday	HK		Monday	HK
Monday	Call		Monday	Call
Tuesday	LE		Monday
Tuesday	Top 50		Monday
Thursday	IPS		Tuesday	LE
Friday	Cov		Tuesday	Top 50
Friday	Dir		Tuesday
			Tuesday
			Wednesday
			Wednesday
			Wednesday
			Thursday	IPS
			Thursday
			Friday	Cov
			Friday	Dir
			Friday
			Friday

 

[Fluff]

How about

Book1
	A	B	C	D	E	F
1		Country	Item		Lookup value:	Results
2		Monday	Pipe		Monday	Pipe
3		Monday	HK		Monday	HK
4		Monday	Call		Monday	Call
5		Tuesday	LE		Monday
6		Tuesday	Top 50		Monday
7		Thursday	IPS		Tuesday	LE
8		Friday	Cov		Tuesday	Top 50
9		Friday	Dir		Tuesday
10					Tuesday
11					Wednesday
12					Wednesday
13					Wednesday
14					Thursday	IPS
15					Thursday
16					Friday	Cov
17					Friday	Dir
18					Friday
19					Friday
CPA C&L

Cell Formulas
Range	Formula
F2:F19	F2	=IFERROR(INDEX($C$2:$C$9,AGGREGATE(15,6,(ROW($C$2:$C$9)-ROW($C$2)+1)/($B$2:$B$9=E2),COUNTIF(E$2:E2,E2))),"")

 

[nikhil0311]

Awesome. However if i have to repeat the same for next month dates its not working

 

[Fluff]

What dates? you just showed days of the week, not dates.

 

[nikhil0311]

What dates? you just showed days of the week, not dates.

If i copy e2 to e19 and paste it on e20 onwards then the formula doesn’t work..
basically i am trying to update these details into a monthly calendar

 

[Fluff]

If i copy e2 to e19 and paste it on e20 onwards then the formula doesn’t work..

That's because there is nothing left to output, you already have all the values from col C.