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

#### Waffles255

##### New Member
=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..

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

#### Fluff

##### MrExcel MVP, Moderator
+Fluff v2.xlsm
ABCD
1CourseNameSurnameFee
21-55 dayAE23
32-55 dayBF24
42-55 dayCG25
51-55 dayDH26
6
Sheet1

+Fluff v2.xlsm
ABCDE
11-55 day
2NameSurnameFee
3AE23
4DH26
5
6
7
8
Sheet2
Cell Formulas
RangeFormula
B3:D6B3=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

##### New Member
Thanks that should work a treat!!

#### Fluff

##### MrExcel MVP, Moderator
You're welcome & thanks for the feedback.

Replies
1
Views
60
Replies
0
Views
67
Replies
23
Views
180
Replies
2
Views
755
Replies
4
Views
94