Hello,
I am trying to create a summary table on a different tab. If the work center in column G (Sheet1 G4:G29) = the work center on my summary tab (Sheet 2 A2:A20) and the week in column A (Sheet A4:A29) = the week on my summary sheet I want to get my past due hours ( Sheet 1 B4:B29).
Any ideas on what I have done wrong with my formula below?? I keeping getting an #N/A error and I'm not sure what I've done wrong. I attached my spreadsheet in case you wanted to review it. I know that visually seeing things helps sometimes. Thanks.
=INDEX(Sheet1!$B$4:$B$29,MATCH(1,IF(Sheet1!$G$4:$G$29=Sheet2!$A$2:$A$20,IF(Sheet1!$A$4:$A$29=Sheet2!$B$1,1)),0))
Bookmarks