CTaylor1968
Vendor
I have created a spreadsheet based on new applications received. I want to have a column that gives the name of a school and whether there is a vacancy (Y or N). Another column records all applications received and lists which school the applicant would like to be appointed to. I want to put in a formula in the column that gives the applicant's preferred school to look up the list of vacancies at a school (2 columns), and if there is a vacancy to highlight the column. So for example, column A would list the schools, column 2 would list Y or N for vacancy, column S would list a school that an applicant wants to be appointed to. So if column S includes a school that has a Y against it, it will highlight. Does this make sense? Can somebody help me with this please? Thanks ever so.