Help comparing 2 sets of data

[yoshiredz]

Hi all,

I have two tabs of data (a lot of data) one is from WFM system, another is from HR with absence info. I need to compare the two to create a results tab that shows name, manager, absence reason, date and paid hours. I need to know what hours are showing in WFM and what hours are showing in HR, if they match, GREAT! If not, an action is needed.
I currently have a spreadsheet that kinda does all of this, but it is so slow and crashed constantly. I think there are too many vlookups and sumifs etc..
I have added some screenshots hopefully they make sense. The calculations tab is how ideally the result will look, but I am open to options as I am not sure what is possible.
thanks in advance

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Comparing two tables
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.