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

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

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

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


.

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


.

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


.


.