If Today Formula Assistance

[Parebody]

Using Microsoft Office Excel Professional Plus 2016. I am attempting to create an IF TODAY formula that will recognize today's date within a range of cells, and if true, will shows the contents of the adjacent cell next to the cell that contains today's date, regardless of where in the range today's date is located. Any ideas? New to this forum and to formula's in general, so bare with me.

 

[jtakw]

Hi,

You didn't provide any specifics for your data, so the following is a sample based on your description:

Book1
	A	B	C	D
1	1/1/2018	1000		4000
2	1/2/2018	2000
3	1/3/2018	3000
4	1/4/2018	4000
5	1/5/2018	5000
6	1/6/2018	6000
Sheet3

Cell Formulas
Range	Formula
D1	=LOOKUP(TODAY(),A$1:A$6,B$1:B$6)

 

[Parebody]

I apologize. As I said, I am new to forum's and wasn't sure how to attach information yet. Your suggestion worked perfectly. I thank very much!

 

[jtakw]

No problem at all, you're very welcome, welcome to the forum.