Display Planned vs Actual Project assigned to the Resource for the specified Date

[zaheer.munir]

Hi Team, Can you help me on this?

I have a planning (HH_Planning) sheet contains list of projects assigned to the Resource on a particular date, similarly for Actual project worked in HH_Activities. By looking at these sheets values, in "project planned vs actual" sheet I want to show the project name planned for the resource name (in A3) for the specified date in B3 from HH_Planning sheet, and to show the actual project name worked by the resource name (in A3) for the specified date in B3 from HH_Activities sheet.

Could you please with vlookup or index and match formula to bring out the planned and actual project details in "project planned vs actual" sheet.

Please find the sample sheet attached for references.