Page 1 of 2 1 2 LastLast
Results 1 to 10 of 11

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

  1. #1
    Seeker ajyexcel's Avatar
    Join Date
    Dec 2020
    Posts
    10
    Articles
    0
    Excel Version
    Office 365

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,661
    Articles
    0
    Excel Version
    Office 365 Subscription
    Attach a sample workbook, please.
    Ali
    Enthusiastic self-taught user of MS Excel!

  3. #3
    Seeker ajyexcel's Avatar
    Join Date
    Dec 2020
    Posts
    10
    Articles
    0
    Excel Version
    Office 365
    Hi Ali,
    Thank you for your response.
    Uploaded..
    Attached Files Attached Files

  4. #4
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,661
    Articles
    0
    Excel Version
    Office 365 Subscription
    Here you go:

    =LOOKUP(2,1/((Sheet2!$A$2:$A$11=A2)*(Sheet2!$C$2:$C$12=4)),Sheet2!$B$2:$B$12)
    Ali
    Enthusiastic self-taught user of MS Excel!

  5. #5
    Seeker ajyexcel's Avatar
    Join Date
    Dec 2020
    Posts
    10
    Articles
    0
    Excel Version
    Office 365
    Thank you So much !!

    It worked !!

  6. #6
    Seeker ajyexcel's Avatar
    Join Date
    Dec 2020
    Posts
    10
    Articles
    0
    Excel Version
    Office 365
    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!!

  7. #7
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,661
    Articles
    0
    Excel Version
    Office 365 Subscription
    Provide a sample showing this and I will advise.
    Ali
    Enthusiastic self-taught user of MS Excel!

  8. #8
    Seeker ajyexcel's Avatar
    Join Date
    Dec 2020
    Posts
    10
    Articles
    0
    Excel Version
    Office 365
    Hi Ali,

    Attached for your review
    Attached Files Attached Files

  9. #9
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,661
    Articles
    0
    Excel Version
    Office 365 Subscription
    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)),"")
    Ali
    Enthusiastic self-taught user of MS Excel!

  10. #10
    Seeker ajyexcel's Avatar
    Join Date
    Dec 2020
    Posts
    10
    Articles
    0
    Excel Version
    Office 365
    Hi Ali,

    Great .. it worked ..
    Thanks Much !!!

Page 1 of 2 1 2 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •