Combining info from others in complex vlookup?

[excelthat]

Hi there,

Situation
Have 1000+ employee data broken out into three worksheets. One worksheet has all comp and date of change for each employee since hire, second tab has change in level and date of change for each employee since hire, third tab has location and date of change since hire. Each sheet has the employee's name and their unique employee ID. Each spreadsheet has multiple entries for each employee.

Goal
Would like to combine all worksheets into the comp change worksheet, such that each entry for comp change has a corresponding level and location. Need to be able to sort information without breaking formulas.

Issue
Because dates differ in each subsequent tab there is not a second key in addition to unique employee ID to key on to bring in another piece of qualitative data.

Please help!

[AliGW]

Welcome to the forum.

Which 'latest' version do you have? There are several, so please be precise in your forum profile.

This sounds like a PowerQuery candidate. There are instructions at the top of the page explaining how to attach your sample workbook.

[excelthat]

Thanks Ali!

Added sample data. Hoping to snap info in VTI tab and Level tab to Base history tab such that it takes the amount equals the Compensation: Date or is closest to that date but not later.

Thanks