Matching students to teachers based on set crteria

[mdexcel]

I am looking to match students from the students table to teachers in the Teacher Table. The criteria is the following:

1. A teach can only have one student
2. Student should be matched with a teacher based on the following :
   1. Their preferred area in Column N with the Teacher Area in Column C
   2. Choice-1 in column D with Teacher Skill in column B
   3. When all choice-1 students are match, a second run to match should use Choice-2 in column E and so on until all students are matched
3. Student labeled as walkers in column B should be matched first
4. Students labeled as Carpool in column B and Yes in Column C should be matched second
5. Students labeled as carpool in Column B and NO in column C should be matched third
6. Final product should list all the matched students with their teachers, one table list student ID’s to their respective teacher ID.
7. No matched students should be in a separate list.

Note the actual data set is 1500 rows, this is just a sample.

Thank you for the help


Students table

https://drive.google.com/file/d/1cMmum1x2v3iXGW1tcx-JJEdADN4ofZqh/view?usp=sharing


Teachers Table
https://drive.google.com/file/d/1JUIg9cxvbXdrXJC3w4YpyE7awX0GVKqs/view?usp=sharing