How do I make this formula look up the next item and then the third and then fourth etc..

[Waffles255]

=INDEX(frmCourses!$B$2:$D$5,MATCH('55 Day 1'!$A$1,frmCourses!$A$2:$A$5,0),MATCH('55 Day 1'!B$2,frmCourses!$A$1:$D$1,0)) Second Pic Forumla

I tried using Mr Excel plugin but its not showing the other tabs...

I am trying to make an input sheet with students that gets allocated to different sheets from the input sheet however I want the formula to look for the first then second then third student that that they booked on the course.

This is the Input Sheet :

And then it should pull through to the other tabs which looks like this, I first want the formulas to work right before i work on making it look better

This is the other tabs it should be pulled through from :

It is only retrieving the first one it finds..

Could you please assist thanks in advance

 

[Fluff]

How about

+Fluff v2.xlsm
	A	B	C	D
1	Course	Name	Surname	Fee
2	1-55 day	A	E	23
3	2-55 day	B	F	24
4	2-55 day	C	G	25
5	1-55 day	D	H	26
6
Sheet1

+Fluff v2.xlsm
	A	B	C	D	E
1	1-55 day
2		Name	Surname	Fee
3		A	E	23
4		D	H	26
5
6
7
8
Sheet2

Cell Formulas
Range	Formula
B3:D6	B3	=IFERROR(INDEX(Sheet1!B$2:B$100,AGGREGATE(15,6,(ROW(Sheet1!$A$2:$A$100)-ROW(Sheet1!$A$2)+1)/(Sheet1!$A$2:$A$100=$A$1),ROWS($B$3:$B3))),"")

 

[Waffles255]

Thanks that should work a treat!!

 

[Fluff]

You're welcome & thanks for the feedback.