• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to retrieve data from one worksheet to another

Y

Yitzhackm

Member
Hi all, I have a question, I have two worksheets, the “Active” and “Corrective Action”. “Active” list all of my active employees, “Corrective Action” host all the employees that somehow have acquired a corrective action/PSP thought their work life. Correctives are valid for 180 days from the issued date and if an employee acquires a new CA within the time of the previous the new one will take over and the 180 days start there. PSP last for 30 days. What formula can return the latest and most current Corrective Action/PSP from the Corrective Action sheet to the Active?

What I need is the Type, Level and Status.



Thanks for the help
 

Attachments

Narayank991 Thank you, i have added more data, in this case Young has two CA both for Performance. Verbal issued on 10/11/2013 and the written on 11/15/2013. this one the latest takes over and the 180 starts here. same with Manzanares-Romero. although the first one has higher level of importance the second issued for attendance will take over. hope makes more sense. CA is corrective action and issued on three levels, verbal, written and final. PSP is just a documented coaching
 

Attachments

Hi Yitzhackm,

Please check the attached file. Is this what you want?.....I had used MAX() function first to find the latest date form Corrective Action sheet and than uses couples of INDEX & MATCH to find releated values.
 

Attachments

Somendra, Yes this is exactly what I needed, Thank you. just one small problem. The odds of issuing a CA to two employees on the same day is very remotely, However, if it happens with your formula duplicate the CA regardless of type of CA issued. Can you review see attached.

Thank you very much for your help.

 

Attachments

You must log in or register to reply here.
Back
Top