Look up changing value in column, return value of column of corresponding row

[lbickford]

Hi guys! I need help. I need to have a cell display information based on finding today's date in a specific column and returning a different column's value of the corresponding row to where today's date is. On the sheet 'Safety Log' where column A contains today's date, return the value of Column F of the corresponding row to where it finds today's date, so it's always updating as the date changes. Column A in Safety Log has a list of dates from 1/1/15 to 12/31/15. This is all happening in Cell B2 of the "AggAsphalt Graphs" sheet.

Can anyone help? Thank you!

[etaf]

try using
=INDEX('Safety Log'!F:F, MATCH(TODAY(),'Safety Log'!A:A,0))

It will only update when the spreadsheet is calculated or opened
If its left open and not touched - nothing will change

[lbickford]

It worked! Thank you!! That is amazing! I'm such a n00b.

[etaf]

your welcome, thanks for the rep