Hi! I need a formula that will look at the school name in column A and then look at the principal name in column D. The principal on sheet 2 coulumn D is different to return the the name of the new principal. I work with a lot of spreadsheets where the data is all over the place and I am looking for a formula that will allow me to say if row contains a school name on both sheets the pull the data from the specified column to match that school. Sample.xlsx