Hi
I have a spreadsheet I have been strugling with so I decided to go to
some experts to help me out.
I record vacation, sick, and edo time on an excel spreadsheet. I have
set it up so that the EDO autopopulate because they reoccur once every
4 weeks. Now I am trying to autopopulate the vacation, which is
random.
They submit their vacation in advance so I want to put it into a
yearly calendar and when I update the weekly excel sheet not only
their EDO autopopulate their Vacation does too.
RIght now I have 2 tabs, one for the week that I manually enter their
sick, and vacation, and their EDO (autopopulate). 2nd tab is their
EDO sheet where all their EDO info draws from. I have inserted a 3rd
sheet with a yearly calendar to enter their vacation on but now I want
the 1st sheet to check the EDO sheet and the Vacation sheet and put it
the info into the 1st tab.

Once I have this completed on a weekly basis I also want to sum all
the V (vacation), S (sick), Edo (earned day off) etc. I am trying to
add a number value to them and am not have any luck I I have tried
this formula =SUMPRODUCT(LOOKUP(E3:K3, $O$4:$O$7, $P$4:$P$7))
but am getting an #N/A. My Spreadsheet is kind of complicated and
has
a bunch of different formulas so I am not sure if that may be the
reason I am getting the error or not.

Please Help!!