Our company retains a list of potential applicants/hires for various jobs in several fields within our company. Not every applicant is eligible for all fields and the spreadsheet I've created indicates those fields for which they are not eligible to be considered. For those fields that they are eligible, the applicant has rank ordered their preference for the given field and the first column indicates a score they were assigned based on the resume they submitted to the company. When we have a vacancy, we would like to use the spreadsheet to find the first available candidate for each available field, identify the fields they are eligible to be considered in and they in the status column, indicate either one of the following hiring actions: "Hire", "Defer", "Not Available", "Declined". My thought was to use combinations of Index/Match, Find, Select, etc but admit that at this point, I'm over me head and we don't want the administrative assistant selecting and approaching the wrong candidate if the candidate isn't eligible for the job.
EDITED (SirJB7)
EDITED (SirJB7)
Last edited by a moderator: