Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Functions and Formulas » How to work on Vlookup with Dates as criteria?

How to work on Vlookup with Dates as criteria?

Previous | Next
Latest post Thu, Jun 17 2010 4:16 AM by Bob Phillips. 1 replies.

  • Thu, Jun 17 2010 1:14 AM

    • geng
    • Not Ranked
    • Joined on Thu, Jun 17 2010
    • Posts 1
    • Points 21

    How to work on Vlookup with Dates as criteria?

    New Sample.xls
    Reply |Contact

    I created a simplier and easier sample so not to confuse myself and the one who's helping me.

    I just need to return a certain data to the cells higlighted in yellow, based on the criteria on B6 and C6.

    The detailed explanation is on the attached workbook.

    I really appreciate your help.

    Thanks!
    • Post Points: 21

  • Thu, Jun 17 2010 4:16 AM In reply to

    Re: How to work on Vlookup with Dates as criteria?

    Reply |Contact |Mark as Answer

    Does this in B7 do it?

     

    =INDEX(Data!B:B,MATCH(Output!B6,Data!B:B,0)-ROW(A1))

    Regards

    Bob

    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.