I need help converting this statement into an excel formula:
If I have a name in one worksheet and I want to look up the name in another
worksheet to find out a certain code and based on that code, I want to do a
calculation it it is blank and if it's not I want a 0.

For example: Worksheet 1 contains a list of names and hourly rates.
Worksheet 2 contains names and codes. If I start with worksheet1,A1 and get
the name ADAMS and match the same name somewhere in column A on worksheet2.
On worksheet 2 is a code. If it is blank, then I want to multiply the hourly
rate on worksheet 1 for ADAMS by 40 else I to return a 0.

Thank you in advance.