Using the Microsoft Project "Analyze Timescaled Data in Excel" feature (View,
Toolbars, Analysis), I can export project Resource Work in summary to Excel.
The feature creates a spreadsheet with the timeline on Row 1, Resource Name
on Row 2, and Resource Work on Row 3 by associated time periods for each
named resource in MS Project. In a separate Excel workbook, I list the
"approved" resources that are allocated in my project budget. I need to
ensure that resource names listed in MS Project match the resource names in
my Excel budget. If there is a resource listed in the MS Project export
worksheet that was not listed in the budget worksheet, I want to list the
Resource Name, hours charged within the project timeline. I was going to use
the VLOOKUP or HLOOKUP function to confirm the Resource Name on row 2 of the
export, but unsure how to reference the Resource Work on row 3 for reporting.

Any assistance or suggestions would be greatly appreciated