K
Karin
I have a workbook that has two tabs. One tab contains the range to look up
from. the other tab is a report with calculations that draws numerical data
from the lookup table based on employee name.
The calculating sheet has multiple columns, four of which look up data, and
several others that calculate from the looked-up data. If I use this:
=IF(ISERROR(VLOOKUP($A10,Week3,3,FALSE)),0,VLOOKUP($A10,Week3,3,FALSE))
everything is fine, as 0 is put in place of an error code.
However, this leaves me wondering if I have errors, so I changed the 0 to
"CHECK" so I could find problems.
BUT, if I am only on Week1 (of 4 weeks), week 2, 3, 4 have "CHECK" in the
fields as there is no data yet. This then throws all the calculations into
errors.
I'm trying to set this up to be used by multiple people who are not
experienced enough to play with the formulas. That's why the formulas are
already in week2-3-4.
Any suggestions for how to do error checking by week without throwing off
all the calculations?
from. the other tab is a report with calculations that draws numerical data
from the lookup table based on employee name.
The calculating sheet has multiple columns, four of which look up data, and
several others that calculate from the looked-up data. If I use this:
=IF(ISERROR(VLOOKUP($A10,Week3,3,FALSE)),0,VLOOKUP($A10,Week3,3,FALSE))
everything is fine, as 0 is put in place of an error code.
However, this leaves me wondering if I have errors, so I changed the 0 to
"CHECK" so I could find problems.
BUT, if I am only on Week1 (of 4 weeks), week 2, 3, 4 have "CHECK" in the
fields as there is no data yet. This then throws all the calculations into
errors.
I'm trying to set this up to be used by multiple people who are not
experienced enough to play with the formulas. That's why the formulas are
already in week2-3-4.
Any suggestions for how to do error checking by week without throwing off
all the calculations?