rosetc16
New member
- Joined
- Apr 22, 2017
- Messages
- 43
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Excel 2016
Using the data list, I want to get the Student ID via the formula and then use a vlookup function to look up the student name, priority, and class (there will be conditional formatting later based on these vlookup values). The formula will be copy and pasted in every "ID" column... Below is the priority designation of who gets put first, second, third, etc. in the specific college that is listed.
DESIRED RESULT (Listed by Priority)
1. PRIORITY AND SENIOR
2. SENIOR
3. PRIORITY AND JUNIOR
4. JUNIOR
*SCHOOLS WITH MULTIPLE IN EACH CATEGORY WILL BE LISTED IN ALPHABETICAL ORDER (The data will be in alpha order)
Attached is an example with a desired result and the data.
DESIRED RESULT (Listed by Priority)
1. PRIORITY AND SENIOR
2. SENIOR
3. PRIORITY AND JUNIOR
4. JUNIOR
*SCHOOLS WITH MULTIPLE IN EACH CATEGORY WILL BE LISTED IN ALPHABETICAL ORDER (The data will be in alpha order)
Attached is an example with a desired result and the data.