Nested if's and lookup

[rj shoe]

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.

 

[T. Valko]

Try this:

=IF(VLOOKUP(A1,Sheet2!A$1:B$10,2,0)="",B1*40,0)

 

[rj shoe]

You are a wonder!!! It works. Thank you VERY MUCH!

 

[T. Valko]

You're welcome. Thanks for the feedback!