Enter formula in C2 and pull it to the right and then down.

Formula: copy to clipboard
=IFERROR(VLOOKUP($B2,$G:$I,COLUMNS($B:B),0),"Not Found")