:confused2:Have a database set up listing our interns (Current Tab). It list their name, requisition number, manager's name, job title and what term (Spring, Summer, Winter). A requistion is good for usually 3 terms, but some are only for 1 term.
I want to pull from my database to the form (Test Tab) the manager name, job title and requistion and then the name of the student for each term.
I thought I had a solution since most requisitions are 3 terms but then I ran into problems when a requisition was for only 1 term. My formula would not work.
This is an example of my formula. I am sure there is a better way.
=IF(AND(Current!$E3<>Current!$E2,Current!$C3<>Current!$C2),Current!$E3,IF(AND(Current!$E4<>Current!$E3,Current!$C4<>Current!$C3),Current!$E4,IF(AND(Current!$E5<>Current!$E4,Current!$C5<>Current!$C4),Current!$E5,"")))
Any help on how to do this would be appreciated.
I have attached a sample of the worksheet.
I want to pull from my database to the form (Test Tab) the manager name, job title and requistion and then the name of the student for each term.
I thought I had a solution since most requisitions are 3 terms but then I ran into problems when a requisition was for only 1 term. My formula would not work.
This is an example of my formula. I am sure there is a better way.
=IF(AND(Current!$E3<>Current!$E2,Current!$C3<>Current!$C2),Current!$E3,IF(AND(Current!$E4<>Current!$E3,Current!$C4<>Current!$C3),Current!$E4,IF(AND(Current!$E5<>Current!$E4,Current!$C5<>Current!$C4),Current!$E5,"")))
Any help on how to do this would be appreciated.
I have attached a sample of the worksheet.