Hello - I have two lists of data 1. text of degree courses titles and 2. list of administrators for those degree courses. How can I get excel to return the associated person's name in the adjacent cell containing the degree course? I thought I might be able to use the IF function (something like if cell A1=BA Music return Adam Smith in cell D2), so that all cells in the D column return the associated person's name based on the degree title.......