extract data based on todays date

[isriam]

I'm looking to make a sheet that has columns A as dates 7 days apart, and columns B:F have data. Flow is left to right, row A1:F1. I'd like to then select the row based on a today through the date in A1.

1/1/2019	1	2	3	4	5
1/8/2019	10	20	30	40	50
1/15/2019	100	200	300	400	500

<colgroup><col><col span="4"><col></colgroup><tbody>
</tbody>

So if today is 1/5/2019, output in row 5 what appears in row 1. This will be done in separate sheets, so sheet1 has the output, and sheets2-10 are the input data. Tried VLOOKUP and it doesn't work well for the variable date being anytime >= A1 but <A2.

 

[steve the fish]

Do you mean like this?

=VLOOKUP(TODAY(),$A$1:$F$3,COLUMNS($A$1:A1),1)

You can replace TODAY() with a cell reference if you want.

 

[isriam]

Thanks, but thats only returning 1 cell, I need the whole row A2:F2 returned.

 

[steve the fish]

Did you not try dragging it across?

 

[isriam]

oh thank, you, i got it to work! i had to apply it across the row and not expect it to pull the entire row. so copy paste the formula from A6:F6.