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" <(E-Mail Removed)> wrote in message
> news:1F0A97D9-8487-4DB1-A684-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:E7855958-9F26-4602-86A5-(E-Mail Removed)...
> >> >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
> >> > --
> >> >
> >>
> >> .
> >>
>
> .
>
Similar Threads
