If function

[quiggdavid]

I want to create something on the first sheet that tells me if todays date is shown in a cell. The dates are all in column D and If todays date is shown I want it to show me the contents of the cell in B


I thought of an If function that says is the date = today then show me address on main sheet but I do not know how to execute this formula. Anyone know how or got any ideas how I would do this?

Basically my idea follows the structure if d3=today then show b3.

If anyone can think of a cleverer way of showing this info please pitch in your reply!!!


Thanks

Dq

[6StringJazzer]

This formula looks for today's date in column D, and returns the value in column B in the corresponding row:

=INDEX(B:B,MATCH(TODAY(),D:D,0))

Edit: This will only work if the dates in column D are integer dates. If they are date+time then it won't find a match.

[brokenbiscuits]

=IF(ISERROR(MATCH(TODAY(),Sheet1!D:D,0)),"",(INDEX(Sheet1!B:B,MATCH(TODAY(),Sheet1!D:D,0),1)))

Does that work?

[Marcol]

Try this

Please Login or Register  to view this content.

Hope this helps

[EDIT]
Browser not updating yet again!