Not able to figure out how to fetch a column value present in a different excel sheet

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
 
Hi Ali,
Thank you for your response.
Uploaded..
 

Attachments

  • VLOOKUP enhancement.xlsx
    9.9 KB · Views: 14
Here you go:

=LOOKUP(2,1/((Sheet2!$A$2:$A$11=A2)*(Sheet2!$C$2:$C$12=4)),Sheet2!$B$2:$B$12)
 
Thank you So much !! :)

It worked !!
 
Can I ask One more question related to this?

Some dates in sheet 2 are blank , when I try to return those phase, its showing "1900-01-00" instead of blank

Is there any way to show this value as blank

Thank you for all your help!!
 
Hi Ali,

Attached for your review
 

Attachments

  • VLOOKUP enhancement- Dates formatted as 1900.xlsx
    11 KB · Views: 4
Please try this:

=IFERROR(1/(1/LOOKUP(2,1/((Sheet2!$A$2:$A$15=A2)*(Sheet2!$C$2:$C$15=4)),Sheet2!$B$2:$B$15)),"")
 
Hi Ali,

Great .. it worked ..
Thanks Much !!!
 
Back
Top