Vlookup formula to select and highlight (conditional formatting) multiple results

Hi All,
I am putting together a spreadsheet (example attached) and I've hit a wall.

If I enter a delegates name in a A3, their respective date of birth appears in B3 using the following vlookup formula - =VLOOKUP(A3,G2:J5,2,FALSE)
I would also like to be able to highlight the delegates current subject in column C and level they are currently working at in column D when I enter their name. (column E is manually completed at the end of each session)

I've attached an example sheet showing the my layout and the data source (which currently numbers over 100 delegates).
Any help to achieve the above will be appreciated

regards,

attendance example.xlsx

Thanks protonLeah.

It took a bit of tweaking but is now working as required.