I have a spreadsheet that lists all of our candidates by name and the corresponding manager. It also includes the position number they are interviewing for.
On a separate sheet, I have the position number in cell i7, I'd like $j8 to show the candidates name. If there have been 10 interviews...