I have 4 sheets. “Jane Doe, John Smith, Keven Brown, and Jean Grey” Each of these sheets contains information associated with an employee.

I want to be able to populate the Current Active Employee sheet cells D-Q with the information from each of the sheets based on if the employee number matches/is the same.

I have inserted this equation on ‘Current Active Employees’!D1-Q7, but have not gotten any results.

Any suggestions?

​I have 4 sheets. “Jane Doe, John Smith, Keven Brown, and Jean Grey” Each of these sheets contains information associated with an employee. I want to be able to populate the Current Active Employee sheet cells D-Q with the information from each of the sheets based on if the employee number matches/is the same. I have inserted this equation on ‘Current Active Employees’!D1-Q7, but have not gotten any results. Any suggestions?  Read More

​