Okay, so I know you experts will have an answer for me. I am trying to have my spreadsheet populate the TITLE on "Student Worker Pay" sheet automatically based on "Student Worker List" sheet. If Student Worker Pay A81, B81 = Student Worker List A:A & B:B and Student Worker Pay D and E fall within the dates of Student Worker List D and E, then it will enter in Student Worker List C in Student Worker Pay C81.
I have been trying all of this in Row 81.
Student Worker List is the reference sheet where all of the data should reference and pull from.
Any suggestions....I am not an excel master. :-)
Thank you12-13 budget-Test 9-4-12.xlsx
Is there a way to show >= to D:D and <= E:E using this
=IF(A81="","",INDEX('Student Worker List'!$C$2:$C$1000,MATCH(A81&B81&D81&E81,'Student Worker List'!$A$2:$A$1000&'Student Worker List'!$B$2:$B$1000&'Student Worker List'!$D$2:$D$1000&'Student Worker List'!$E$2:$E$1000,0)))
Bookmarks