I am working on a project and I need help. If you take a look at the attached spreadsheet you will find two tabs one called data and the other called result.
What I am trying to do is to add up all the hours worked by a particular employee from the table below.
MONTH EMPLOYEE ID REGULAR HOURS...
Can you please help me, I want to create two input options to search a report (by zip code & City). I have the formula to match the zip code that is typed-in which is =MATCH($D$1,'Zip Export'!F:F,). How do I include in this formula to also match city that is typed in.
Thank you.