Extracting Data to a New Sheet Based on Dates

So I have a cell on sheet one that I want show data from another sheet using the todays date in one column and find the information in the cell to the right in another column corresponding with that date. So sheet 1 k12 is the cell I want the information to go into. Sheet 2 has a range of cells with multiple dates (B7:B452) that I need to look through and match with todays date. And find the data to the right of that date in another range of cells (D&:D452) for cell k12.

Welcome to the forum!

Our rules require you to come up with useful thread titles, that is titles that explain your problem. To show you what I mean, I have changed yours for you this time, but we expect you to produce better thread titles yourself in future, please.

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

Looking at the attachment I believe that you want the retrieval formulas to go into cells K20 and M20.
K20: =INDEX('ICiMS Flow'!D7:D452,MATCH(TODAY(),'ICiMS Flow'!B7:B452,0))
M20: =INDEX('ICiMS Flow'!E7:E452,MATCH(TODAY(),'ICiMS Flow'!B7:B452,0))
On the other hand, with a few modifications to the ICMS Flow sheet (see D4:S4), you could populate the entire range on the Snapshot sheet using:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.