complicated Vlookup?

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
--
 
R

Rick Rothstein

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,"")
 
B

B Lynn B

you have given three arguments to the IFERROR function, (perhaps thinking of
how IF is structured), but it takes only 2. Those are: 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.
 
R

Rick Rothstein

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?
 
D

Doug

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top