Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP and its properties | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Vlookup | Excel Discussion (Misc queries) | |||
Vlookup with multiple conditions | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |