Numbers vlookup error message - "ISERROR requires one argument, but was given 4".

[thejollyfatman]

Hi all, i have a numbers workbook containing 14 spreadsheets, 1 for takings for each month, one for the year total, and one for a weekly takings view of how my business is doing.

i am trying to get the weekly sheet to show the information taken from all the other sheets when prompted, so i have used a vlookup to find all the necessary information. it works on when i enter some dates and not with others and i cant figure out why. i keep getting the error message "ISERROR requires one argument, but was given 4".

here is the formula :

=IFERROR(VLOOKUP($B11,Takings OCT 09 :: C3:S157, 17), ISERROR (VLOOKUP($B11, Takings APR 09 :: C3:S157, 17), ISERROR(VLOOKUP($B11, Takings MAY 09 :: C3:S157),17), ISERROR(VLOOKUP($B11, Takings JUN 09 :: C3:S157), 17), ISERROR(VLOOKUP($B11, Takings JUL 09 :: C3:S157, 17), ISERROR(VLOOKUP($B11, Takings AUG 09 :: C3:S157),17), ISERROR(VLOOKUP($B11,Takings SEPT 09 :: C3:S157, 17), ISERROR(VLOOKUP($B11, Takings NOV 09 :: C3:S157), 17), ISERROR(VLOOKUP($B11, TakingsDEC 09 :: C3:S157), 17), ISERROR(VLOOKUP($B11, Takings JAN 10 :: C3:S157), 17), ISERROR(VLOOKUP($B11, Takings FEB 10 :: C3:S157, 17), ISERROR(VLOOKUP($B11, Takings MAR 10 :: C3:S157, 17)))))))


This searches for the date i enter on the weekly spreadsheet, through all the monthly ones.

It works in some cases, but not in others.

Any help would be much appreciated.

Thanks.
Rollie

 

[wrldwzrd89]

Hi all, i have a numbers workbook containing 14 spreadsheets, 1 for takings for each month, one for the year total, and one for a weekly takings view of how my business is doing.

i am trying to get the weekly sheet to show the information taken from all the other sheets when prompted, so i have used a vlookup to find all the necessary information. it works on when i enter some dates and not with others and i cant figure out why. i keep getting the error message "ISERROR requires one argument, but was given 4".

here is the formula :

=IFERROR(VLOOKUP($B11,Takings OCT 09 :: C3:S157, 17), ISERROR (VLOOKUP($B11, Takings APR 09 :: C3:S157, 17), ISERROR(VLOOKUP($B11, Takings MAY 09 :: C3:S157),17), ISERROR(VLOOKUP($B11, Takings JUN 09 :: C3:S157), 17), ISERROR(VLOOKUP($B11, Takings JUL 09 :: C3:S157, 17), ISERROR(VLOOKUP($B11, Takings AUG 09 :: C3:S157),17), ISERROR(VLOOKUP($B11,Takings SEPT 09 :: C3:S157, 17), ISERROR(VLOOKUP($B11, Takings NOV 09 :: C3:S157), 17), ISERROR(VLOOKUP($B11, TakingsDEC 09 :: C3:S157), 17), ISERROR(VLOOKUP($B11, Takings JAN 10 :: C3:S157), 17), ISERROR(VLOOKUP($B11, Takings FEB 10 :: C3:S157, 17), ISERROR(VLOOKUP($B11, Takings MAR 10 :: C3:S157, 17)))))))


This searches for the date i enter on the weekly spreadsheet, through all the monthly ones.

It works in some cases, but not in others.

Any help would be much appreciated.

Than
Rollie

I can tell just by looking at your formula that the problem is many, many misplaced parentheses. Without access to my Mac, though, I can't easily determine exactly what's wrong... but I can give some general guidance.

1. Check, double-check your arguments! Your parentheses are inconsistent in several places in your formula. For example, some groups inside the IFERROR function have a ) before the , 17 and others do not.
2. Numbers is correct that ISERROR only takes one argument - this is caused by not closing the parenthesis group properly where the VLOOKUP ends, inside the call to ISERROR. There appear to be many, many cases where you need not one, but TWO closing parentheses after each group.

 

[thejollyfatman]

OK, ive done that and tidied it up.

It now looks like this:

=IFERROR(VLOOKUP($B10,Takings OCT 09 :: C3:S157, 17)),
ISERROR(VLOOKUP($B10,Takings APR 09 :: C3:S157, 17)), ISERROR(VLOOKUP($B10,Takings MAY 09 :: C3:S157, 17)), ISERROR(VLOOKUP($B10,Takings JUN 09 :: C3:S157, 17)), ISERROR(VLOOKUP($B10,Takings JUL 09 :: C3:S157, 17)), ISERROR(VLOOKUP($B10,Takings AUG 09 :: C3:S157, 17)), ISERROR(VLOOKUP($B10,Takings SEPT 09 :: C3:S157, 17)), ISERROR(VLOOKUP($B10,Takings NOV 09 :: C3:S157, 17)), ISERROR(VLOOKUP($B10,Takings DEC 09 :: C3:S157, 17)), ISERROR(VLOOKUP($B10,Takings JAN 10 :: C3:S157, 17)), ISERROR(VLOOKUP($B10,Takings FEB 10 :: C3:S157, 17)), ISERROR(VLOOKUP($B10,Takings MAR 10 :: C3:S157, 17))))

and it is now showing the error - "the formula contains a syntax error".

sorry but im new to all this and am really rather confused .