# reverse index function?

#### warhorse927

##### New Member
I attend a school that is on a Cohort system i.e. A group of people go through the program together. The good thing about this is that our classes are mapped out. We know the start date of every class we will take over the next 2.5 years. The problem:
Every Cohort has classes in the same order (different start dates,for now) so I created a table of 9 columns with the Cohort names across the top row. (BBA 501, BBA 502 to BBA 508. These are the column heads. In the row right below this are the number of students in the Cohort.
In the FIRST Colum (A) are the classes (History 202, English 111, BIO 210...)
In the body of the table under each Cohort name and # of students are the start dates for each class for that cohort. These are usually unique but there are two cohorts that coincide. My problem. between two dates, I need to know which cohorts have a particular class. To put it simply, I need to evaluate the intersection of the row and column and have it return the column head.

### Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
No, that returns the intersection, in my case the date. I want to evaluate the date to return the column heading i.e. I have a formula that returns the number of students in a class based on a date range =SUM(IF(orientation!\$B26:\$AA26>Begdate1,IF(orientation!\$B26:\$AA26<Enddate1,abastud,0),0))entered as an array formula beside each class on a different sheet. orientation is the sheet name,abastud is the number of students range (row)to get the number from. This works but I can't modify it to get the Cohort NAME.

Replies
14
Views
1K
Replies
5
Views
516
Replies
18
Views
948
Replies
7
Views
263
Replies
7
Views
683

1,217,677
Messages
6,137,941
Members
450,100
Latest member
mscetr

### 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