I have a spreadsheet where I'm tracking Employee Salary History information on one sheet and have a summary page on another sheet.
There are 3 columns on the Employee Salary History Information Sheet: Date, Description and Amount
On the Summary Page, I have a drop down box in cell B1 that allows me to select the employee name and I use VLookups to pull in the Hire Date, DOB and other relevant employee information.
I'd like to add an area to the bottom of this that will pull in the Date, Description and Amount from the Employee Salary History Information Sheet for the specific employee.
I don't have experience with array formulas and it seems like this would be the best solution for what I'm looking for.
Could you please help me with the formula?
There are 3 columns on the Employee Salary History Information Sheet: Date, Description and Amount
On the Summary Page, I have a drop down box in cell B1 that allows me to select the employee name and I use VLookups to pull in the Hire Date, DOB and other relevant employee information.
I'd like to add an area to the bottom of this that will pull in the Date, Description and Amount from the Employee Salary History Information Sheet for the specific employee.
I don't have experience with array formulas and it seems like this would be the best solution for what I'm looking for.
Could you please help me with the formula?