I don't know if I need to use VLOOKUP, INDEX, MATCH or a combination of them. I need to get the employees review dates from Sheet 2 into Sheet 1. The dates on Sheet 2 are in a row, and I need them on Sheet 2 in a column, but I need them in the correct month. So using Sheet 1 A3 as an example, I need the dates from Sheet 2 to populate in the correct month in Sheet 1.
I hope I explained this enough. I am good with basic excel, but now I am needing help with advance formula's.
Is there a way to do get this to work.
Sheet 1
A B C D E
<tbody>
</tbody>
Sheet 2
A B
<tbody>
</tbody>
I hope I explained this enough. I am good with basic excel, but now I am needing help with advance formula's.
Is there a way to do get this to work.
Sheet 1
A B C D E
Employee | Jan Review | Feb Review | Mar Review | Apr Review |
Doe, John | ||||
Doe, Jane | 1/5/2018 | 2/4/2018 | 3/3/2018 |
<tbody>
</tbody>
Sheet 2
A B
Employee | Review Conducted On |
Doe, John | 3/2/2018 |
Doe, John | 1/2/2018 |
Doe, Jane | 2/4/2018 |
Doe, Jane | 3/3/2018 |
Doe, Jane | 1/5/2018 |
<tbody>
</tbody>