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