Hi adam.dixon,
welcome to the forum
try.. this in B4 and fill down =IF(ISNUMBER(MATCH(A4,E$4:E$7)),INDEX(F$4:F$7,MATCH(A4,E$4:E$7)),"")