Retrieving information fron two sheets

[chriseverclear]

Hi Excel Genius,

I have a question. Here is what i am trying to do.

Sheet 1
A1 B1
Name Approval Date
Jason 12/15/2013
Bob 09/06/2013

Sheet 2

A1 B1 C1
Name Completed Date Comment
Jason 11/15/2013 Completed Date cannot be before after approval date
Bob 10/06/2013 Fine

Can anyone help with the formula? Basically, in sheet 1, all the names and when it was approved is there. In Sheet 2, it will look at sheet 1 approval date and corresponding name. If the completed date is after the approval date, it is fine. If it is before the approval date, it should give some kind of error message.

Can anyone help?

Thank you

[ARGK]

Hi
Cut and paste this formula into Cell C2 on Sheet 2 and copy down accordingly.

=IF(B2>(VLOOKUP(A2,Sheet1!A:B,2,FALSE)),"Fine","Completed date cannot be before the approval date")

Hope this helps.
Good luck.
Tony

[chriseverclear]

Yes, it works beautifully. Thank you so much!!!!!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

[chriseverclear]

Hi,

I thought i had it all figured out, but it doesn't seem to work. I have included the spreadsheet with more details.

There are two tabs in the spreadsheet. Once is the TrainingItems tab and the other one is the Training History. If you look at the column in J2, you will see that there's a formula. All i need is to look at the trainingitemcode and the completion date in Training History. If you go to TrainingItems, it cannot be less equal than the approval date that corresponds to the CW TrainingItemCode.

TrainingItems Tab

CW TrainingItemCode: JCO-EMEA-SOP MQP 3.4.0.02 v1.00 Knowledge
Approval Date: 03/18/2012


Training History
CW TrainingItemCode: JCO-EMEA-SOP MQP 3.4.0.02 v1.00 Knowledge
Completion Date: 02/18/2012
If it is before the approval date, it gives an error message
If it is equal or after the approval date, it is fine.

Thank you guys!

[ARGK]

Hi
This is because in the sample the column being compared was column 2, in your spreadsheet the column being compared is column 7. Use this formula:

=IF(B2>(VLOOKUP(A2,Sheet1!A:B,7,FALSE)),"Fine","Completed date cannot be before the approval date")

Good luck.
Tony

[chriseverclear]

Thank you ARGK. It works!!!!!