Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |