If statements in a Vlookup.
 

I have a Vlookup worksheet that the formula works. It is below

=PRODUCT(VLOOKUP($B3,'PTO '!$A$2:$BM$61,42),$C$3)

This is for a PTO calculation by month. When an employee receives a raise I
have added a current date column (E6) and new rate column (D6). The next
month would be in the O1 position. I want the PTO to be calculated at the
higher rate if there has been a salary increase. I have been trying to add
the following to my formula and not having the right results.

*if( E5<O1, D6, C6)

Anyone have any ideas?

If statements in a Vlookup.
 

=PRODUCT(VLOOKUP($B3,'PTO '!$A$2:$BM$61,42),$C$3)

You don't really need the PRODUCT funtion:

=VLOOKUP($B3,'PTO '!$A$2:$BM$61,42)*$C$3

*if( E5<O1, D6, C6)

How does that relate to the current formula?

--
Biff
Microsoft Excel MVP


"Gallarita" wrote in message
...
I have a Vlookup worksheet that the formula works. It is below

=PRODUCT(VLOOKUP($B3,'PTO '!$A$2:$BM$61,42),$C$3)

This is for a PTO calculation by month. When an employee receives a raise
I
have added a current date column (E6) and new rate column (D6). The next
month would be in the O1 position. I want the PTO to be calculated at the
higher rate if there has been a salary increase. I have been trying to
add
the following to my formula and not having the right results.

*if( E5<O1, D6, C6)

Anyone have any ideas?

If statements in a Vlookup.
 

For simplicity's sake, you needn't use PRODUCT(), you can merely use *

=VLOOKUP($B3,'PTO '!$A$2:$BM$61,42)*$C$3

Trying to determine which cell belongs whre, so here's a guess...

Are you wanting to do this:

=IF($E5<$01,VLOOKUP($B3,'PTO '!$A$2:$BM$61,42)*$C$6,VLOOKUP($B3,'PTO
'!$A$2:$BM$61,42)*$d$6)

?

"Gallarita" wrote:

I have a Vlookup worksheet that the formula works. It is below

=PRODUCT(VLOOKUP($B3,'PTO '!$A$2:$BM$61,42),$C$3)

This is for a PTO calculation by month. When an employee receives a raise I
have added a current date column (E6) and new rate column (D6). The next
month would be in the O1 position. I want the PTO to be calculated at the
higher rate if there has been a salary increase. I have been trying to add
the following to my formula and not having the right results.

*if( E5<O1, D6, C6)

Anyone have any ideas?