Hello Everyone ,

Need your help in resolving one issue, I'm trying trying to fetch the information on Sheet 1 ( date for Specific Phase) from a different excel sheet.( sheet 2)
One of the common information on both the sheets are ID.

One of the column in sheet 1 is ID and other is the information to be fetched from sheet 2 based on each Phase like mentioned below

I tried a VLOOKUP, but got stuck on the date fetching functionality. I don't know if there is any way to perform this task using any other function like vlookup.

As I'm new to excel , I need some assistance in dealing with this problem.

Could anyone let me know how to achieve this solution


Data to be fetched from sheet 2 is Phase date


Thanks in Advance !!



Excel sheet 1

ID Phase 1 Date ........................Phase 4 Date
_______________
1001 2020-02-01........................... 2020-02-04
1002 2020-02-06...........................2020-02-09
1003


Excel Sheet 2

ID Dates Phase#
____________________________________
1001 2020-02-01 1
1001 2020-02-02 2
1001 2020-02-03 3
1001 2020-02-04 4
1001 2020-02-05 5
1002 2020-02-06 1
1002 2020-02-07 2
1002 2020-02-08 3
1002 2020-02-09 4
1002 2020-02-10 5