adjust the ranges as needed
=VLOOKUP(A6,$A$2:$H$500,8,0)