worksheet or tab name : client
Cell G2 formula , Drag down
Formula: copy to clipboard
=IFERROR(VLOOKUP(F2,Planner!B:H,7,),F2)