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

Waffles255

New Member
Joined
Mar 30, 2019
Messages
17
Office Version
  1. 2019
=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 :

1606893567704.png


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 :

1606893612101.png


It is only retrieving the first one it finds..

Could you please assist thanks in advance
 

Some videos you may like

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
Joined
Jun 12, 2014
Messages
50,750
Office Version
  1. 365
Platform
  1. Windows
How about
+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))),"")
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
50,750
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,521
Messages
5,572,625
Members
412,475
Latest member
JaredNAU
Top