Search code examples
excelexcel-formulaexcel-2010excel-2007

How to get data values from sheet. In this week comparison in excel. Using Vlook or?

2 cells with =TODAY()-WEEKDAY(TODAY())+1 and =TODAY()-WEEKDAY(TODAY())+7. One for this week first day and the other one for the last day of the week. How to get data from this week. Am I going to use VLOOKUP? or something formula. Thanks

I am trying return data that matches these dates. For example on the other sheet i do have date 5/29/2018,5/27/2018 ,4/27/2018 and has data values , and on the other sheet i created summary for data where this week from the first day of the week today to last day of the week today 5/27/2018- 6/2/2018 where those data will be the output the data of 5/29/2018,5/27/2018

These are the dates that i will get from 5/27/2018 - 6/2/2018 enter image description here FROM THE DATA HERE enter image description here

I will get the PRF Control # from the dates that will pass through 5/27/2018- 6/2/2018

Solution

  • Sounds like you may be after an index match.

    This is the formula in the summary sheet cell B4 and then dragged down for 7 rows to cover selected week:

    =IFERROR(INDEX(Sheet1!A:A,MATCH(A4,Sheet1!$C:$C,0)),"")

    Summary sheet has the two cells (B2 and C2) which determine the week dates to match on or between.

    Summary sheet

    Summmary sheet

    The data sheet (sheet1) which is referenced by the formulas:

    Sheet1

    The formula attempts to match the dates in summary sheet, with Match function, and uses the position number returned as the row number to Index, which then pulls the PRF Control # in the same row.