D
Doug
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),"",(VLOOKUP($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
--
=(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),"",(VLOOKUP($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
--