Ho to extract school names

[alipezu]

Hi dear Experts,
I have a list of drivers that are working in either one school or two. These schools have different starting time either 7:00 or 8:00.
Now I can easily extract School Names in the 'First School' and 'Second School' according their timings by combining multiple lookup value and lookup array using CTRL+Shift+Enter.
But Here my only Issue is that I want the School names in the 'First School' if the related driver has only one school. It doesn't mater if starting time is 8:00.
Please help me solve this.
Thank you.

[FDibbins]

Not really sure what you want here, but I modified yoyur formula to make it a regulat formula (not ARRAY), and made it a bit more adaptable...
C15=IFERROR(INDEX($D$2:$D$10,MATCH($A15&IF(C$14="first school","7:00","8:00")+0,INDEX($A$2:$A$10&$E$2:$E$10,0),0)),"")
copied down AND across as needed

[alipezu]

Here I will mention first three drivers that have different scenario.
1: David is working in a single school ABC and that is the only school he is working in So the ABC is in correct columns(C15).
2: Richard is working in a single school XYZ and that is the only school he is working in He has no other or Second school.So the school XYZ must be in the 'First School'(C16) not in 'Second School'(D16). And that's the only thing I want to solve.
3: Steve is working in two schools 'First (C17) and Second School (D17). And I have no issue with that.

Please solve my Issue only for Richard.

Thanks.

[samba_ravi]

C15

Please Login or Register  to view this content.

Try this and copy across

[alipezu]

Here is my actual excel workbook and I think that will clarify.

[samba_ravi]

C2

Please Login or Register  to view this content.

D2

Please Login or Register  to view this content.

TRY THIS AND COPY TOWARDS DOWN

[alipezu]

Thank you nflsales, working perfect now. And also thanks to FDibbins.