| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
complicated Vlookup?
I was using this just fine. (returns a percentage change between two lookups)
=(VLOOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1 But when I tried to add IFERROR so that all error values would return a blank, it said that I have to many arguments for this function. =IFERROR(VLOOKUP($Q3,Import!$Q:$CA,4,FALSE),"",(VL OOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1) I have been trying to figure this out for a while. What do I need to be typing in instead? Thanks -- |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
complicated Vlookup?
The IFERROR function only takes two arguments... the expression to be
evaluated and the value to display if there is an error. =IFERROR((VLOOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1,"") -- Rick (MVP - Excel) "Doug" wrote in message ... I was using this just fine. (returns a percentage change between two lookups) =(VLOOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1 But when I tried to add IFERROR so that all error values would return a blank, it said that I have to many arguments for this function. =IFERROR(VLOOKUP($Q3,Import!$Q:$CA,4,FALSE),"",(VL OOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1) I have been trying to figure this out for a while. What do I need to be typing in instead? Thanks -- |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
complicated Vlookup?
you have given three arguments to the IFERROR function, (perhaps thinking of
how IF is structured), but it takes only 2. Those a 1) the function to test for error: and 2) the value to return if error is found. If no error is found then it returns the result of the tested function. "Doug" wrote: I was using this just fine. (returns a percentage change between two lookups) =(VLOOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1 But when I tried to add IFERROR so that all error values would return a blank, it said that I have to many arguments for this function. =IFERROR(VLOOKUP($Q3,Import!$Q:$CA,4,FALSE),"",(VL OOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1) I have been trying to figure this out for a while. What do I need to be typing in instead? Thanks -- |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
complicated Vlookup?
Thanks for your time, but this only returns blank cells throughout the whole
column. -- Thank you! "Rick Rothstein" wrote: The IFERROR function only takes two arguments... the expression to be evaluated and the value to display if there is an error. =IFERROR((VLOOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1,"") -- Rick (MVP - Excel) "Doug" wrote in message ... I was using this just fine. (returns a percentage change between two lookups) =(VLOOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1 But when I tried to add IFERROR so that all error values would return a blank, it said that I have to many arguments for this function. =IFERROR(VLOOKUP($Q3,Import!$Q:$CA,4,FALSE),"",(VL OOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1) I have been trying to figure this out for a while. What do I need to be typing in instead? Thanks -- . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
complicated Vlookup?
You didn't give us any background on the formula you posted, so I simply
assumed it must be working for you. If you are getting nothing but blank cells, then it must mean your formula is generating an error in every cell. Not knowing anything about the construction or background of the formula means we here will not be able to help you debug it. If you put the formula in the cells just the way you posted it (without the IFERROR function), does it work? -- Rick (MVP - Excel) "Doug" wrote in message ... Thanks for your time, but this only returns blank cells throughout the whole column. -- Thank you! "Rick Rothstein" wrote: The IFERROR function only takes two arguments... the expression to be evaluated and the value to display if there is an error. =IFERROR((VLOOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1,"") -- Rick (MVP - Excel) "Doug" wrote in message ... I was using this just fine. (returns a percentage change between two lookups) =(VLOOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1 But when I tried to add IFERROR so that all error values would return a blank, it said that I have to many arguments for this function. =IFERROR(VLOOKUP($Q3,Import!$Q:$CA,4,FALSE),"",(VL OOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1) I have been trying to figure this out for a while. What do I need to be typing in instead? Thanks -- . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
complicated Vlookup?
If I type it in like this with out the IFERROR, it says that the formula
contains an error. =((VLOOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1,"") The formula below works fine, but does not omit the errors. =(VLOOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1 -- "Rick Rothstein" wrote: You didn't give us any background on the formula you posted, so I simply assumed it must be working for you. If you are getting nothing but blank cells, then it must mean your formula is generating an error in every cell. Not knowing anything about the construction or background of the formula means we here will not be able to help you debug it. If you put the formula in the cells just the way you posted it (without the IFERROR function), does it work? -- Rick (MVP - Excel) "Doug" wrote in message ... Thanks for your time, but this only returns blank cells throughout the whole column. -- Thank you! "Rick Rothstein" wrote: The IFERROR function only takes two arguments... the expression to be evaluated and the value to display if there is an error. =IFERROR((VLOOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1,"") -- Rick (MVP - Excel) "Doug" wrote in message ... I was using this just fine. (returns a percentage change between two lookups) =(VLOOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1 But when I tried to add IFERROR so that all error values would return a blank, it said that I have to many arguments for this function. =IFERROR(VLOOKUP($Q3,Import!$Q:$CA,4,FALSE),"",(VL OOKUP($Q3,Import!$Q:$CA,4,FALSE)/(VLOOKUP($Q3,'Old Import'!$Q:$CA,4,FALSE)))-1) I have been trying to figure this out for a while. What do I need to be typing in instead? Thanks -- . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Complicated vlookup/min-max query...please help | Excel Discussion (Misc queries) | |||
| COMPLICATED VLOOKUP | Excel Programming | |||
| Need help with complicated Vlookup, or possibly other function | Excel Worksheet Functions | |||
| Complicated VLOOKUP | Excel Programming | |||
| Complicated Vlookup/count problem | Excel Worksheet Functions | |||
Linear Mode
