Vlookup with conditions
 

I am currently using the formula

IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,3,FALSE))

I need to add a string that not only lookups v5 as above but I also need to
loolooks up j5 and if equals a certain number the formula above would look at
column 4 rather than 3

Does my question make sense?

Thanks

ce

Vlookup with conditions
 

Try something like

IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,3+(J5=99) ,FALSE))

This will return a result from column D unless J5 is 99 and then it return a
result from column E

"Curtis" wrote:

I am currently using the formula

IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,3,FALSE))

I need to add a string that not only lookups v5 as above but I also need to
loolooks up j5 and if equals a certain number the formula above would look at
column 4 rather than 3

Does my question make sense?

Thanks

ce

Vlookup with conditions
 

try
IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,if(j5=12, 4,3),0))


--
Don Guillett
SalesAid Software

"Curtis" wrote in message
...
I am currently using the formula

IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,3,FALSE))

I need to add a string that not only lookups v5 as above but I also need
to
loolooks up j5 and if equals a certain number the formula above would look
at
column 4 rather than 3

Does my question make sense?

Thanks

ce

Vlookup with conditions
 

Sorry, I do not thinkk I gave enough information for my request.
my current formula looks-up the contents in cell V5 in the rate table
$B$2:$F$226.

My problem now is I have 9 employees that get paid at a differetn rate (
located in column 4 in my Vlookup formula). I need to be able to have the
contents of j5:j4000 trigger the vlookup to either column 3 or 4

Sorry for the lack of information on the first request for help

ce

"Don Guillett" wrote:

try
IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,if(j5=12, 4,3),0))


--
Don Guillett
SalesAid Software

"Curtis" wrote in message
...
I am currently using the formula

IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,3,FALSE))

I need to add a string that not only lookups v5 as above but I also need
to
loolooks up j5 and if equals a certain number the formula above would look
at
column 4 rather than 3

Does my question make sense?

Thanks

ce

Vlookup with conditions
 

I don't understand.

--
Don Guillett
SalesAid Software

"Curtis" wrote in message
...
Sorry, I do not thinkk I gave enough information for my request.
my current formula looks-up the contents in cell V5 in the rate table
$B$2:$F$226.

My problem now is I have 9 employees that get paid at a differetn rate (
located in column 4 in my Vlookup formula). I need to be able to have the
contents of j5:j4000 trigger the vlookup to either column 3 or 4

Sorry for the lack of information on the first request for help

ce

"Don Guillett" wrote:

try
IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,if(j5=12, 4,3),0))


--
Don Guillett
SalesAid Software

"Curtis" wrote in message
...
I am currently using the formula

IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,3,FALSE))

I need to add a string that not only lookups v5 as above but I also
need
to
loolooks up j5 and if equals a certain number the formula above would
look
at
column 4 rather than 3

Does my question make sense?

Thanks

ce

Vlookup with conditions
 

So how do you identify these 9 employees? If J5 contains an employee number
then assume that you have a list of the 9 "special" employees numbers in
Z1:Z9 then, adjusting my suggestion above

=IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,3+ISNUMB ER(MATCH(J5,$Z$1:$Z$9,0)),0))

"Curtis" wrote:

Sorry, I do not thinkk I gave enough information for my request.
my current formula looks-up the contents in cell V5 in the rate table
$B$2:$F$226.

My problem now is I have 9 employees that get paid at a differetn rate (
located in column 4 in my Vlookup formula). I need to be able to have the
contents of j5:j4000 trigger the vlookup to either column 3 or 4

Sorry for the lack of information on the first request for help

ce

"Don Guillett" wrote:

try
IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,if(j5=12, 4,3),0))


--
Don Guillett
SalesAid Software

"Curtis" wrote in message
...
I am currently using the formula

IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,3,FALSE))

I need to add a string that not only lookups v5 as above but I also need
to
loolooks up j5 and if equals a certain number the formula above would look
at
column 4 rather than 3

Does my question make sense?

Thanks

ce

Vlookup with conditions
 

Correct! I have 2 lists that contain the two types of employee. I need to use
the VLOOKUP function depending on which list the employee resides ( column 3
for one type, column 4 for the other

ce

"daddylonglegs" wrote:

So how do you identify these 9 employees? If J5 contains an employee number
then assume that you have a list of the 9 "special" employees numbers in
Z1:Z9 then, adjusting my suggestion above

=IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,3+ISNUMB ER(MATCH(J5,$Z$1:$Z$9,0)),0))

"Curtis" wrote:

Sorry, I do not thinkk I gave enough information for my request.
my current formula looks-up the contents in cell V5 in the rate table
$B$2:$F$226.

My problem now is I have 9 employees that get paid at a differetn rate (
located in column 4 in my Vlookup formula). I need to be able to have the
contents of j5:j4000 trigger the vlookup to either column 3 or 4

Sorry for the lack of information on the first request for help

ce

"Don Guillett" wrote:

try
IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,if(j5=12, 4,3),0))


--
Don Guillett
SalesAid Software

"Curtis" wrote in message
...
I am currently using the formula

IF(V5="","",VLOOKUP(V5,Rates!$B$2:$F$226,3,FALSE))

I need to add a string that not only lookups v5 as above but I also need
to
loolooks up j5 and if equals a certain number the formula above would look
at
column 4 rather than 3

Does my question make sense?

Thanks

ce