# 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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

#### 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
117
Replies
0
Views
125
Replies
0
Views
125
Replies
0
Views
48
Replies
0
Views
151

1,130,142
Messages
5,640,380
Members
417,139
Latest member
bdmprasenjit

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back