In A2 =INDEX($H$2:$H$7,MATCH(C2,$G$2:$G$7,0)) and then copy down.