ajyexcel
New member
- Joined
- Dec 17, 2020
- Messages
- 10
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office 365
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
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