I am in need of help , I am making a excel spreadsheet for a football club (this is not for a real football club) that store information on there season ticket applications in which each applicant is designated a seat and all applicants will get a seat until there are non left.

The scenario is, there are a total of 125 seats to be allocated to the applicants, (there will be no more then 65 example applications in the spreadsheet) the worksheet has been created to store information on the applicants (any relevant information like name and address) and then automatically allocates them a seat, the applications are all successful until there are no seats left (a separate cell/ column will say if the applicant is successful or not). All applicants can request there own seat but if their requested seat is taken it must automatically give them the next closest one, for example IF Applicant requests seat A6 BUT A6 has been allocated to another applicant BUT A7 is free THEN applicant will be assigned to seat A7 as it is the 'next best thing'...

It must also be made so if there are not seats left then applicant is not successful and the formula then does not apply and cell is left blank.

NOTE: There are 125 seats in total, 5 stands each with 5 rows and 5 columns in them.

I hope this makes sense to you and you can help i really need this to be solved for me as i'm now running out of time to complete this formula for my college

Thanks for reading!