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.

[TABLE="width: 399"]
<colgroup><col><col span="4"><col></colgroup><tbody>[TR]
[TD="align: right"]1/1/2019[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]1/8/2019[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]50[/TD]
[/TR]
[TR]
[TD="align: right"]1/15/2019[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]500[/TD]
[/TR]
</tbody>[/TABLE]

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.