Nested if's and lookup
 

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.

Nested if's and lookup
 

Try this:

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

--
Biff
Microsoft Excel MVP


"rj shoe" <rj wrote in message
...
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.

Nested if's and lookup
 

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

"T. Valko" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"rj shoe" <rj wrote in message
...
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.

Nested if's and lookup
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"rj shoe" wrote in message
...
You are a wonder!!! It works. Thank you VERY MUCH!

"T. Valko" wrote:

Try this:

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

--
Biff
Microsoft Excel MVP


"rj shoe" <rj wrote in message
...
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.