VBA lookup a name based on a number

Hello everyone
Hope you can help since i'm new to VBA
I want to create a macro that has similarities to the Vlookup function.
The reason for this (illustrated in the Excel sheet) is that i have a list of different codes and the associated names (column F & G). In column B the user then inputs the code, and the macro should then automatically report the associated name in column C. If the user enters a code that doesn't have a name associated it should mark the column C cell as red (see example in sheet)

Thank you