Lookup today's date in a range, and return value of adjacent cell

[Kimmerz29]

I rarely need to do more than basic calculations in Excel these days, and it seems I've forgotten most of what I once learnt!

This one I think should be relatively easy;

Sheet1 -
In column A on there are dates listed (range A1:A200)
In column B we have a number corresponding to each date.

Sheet2 -
In cell C1, I need it to lookup today's date in column A on Sheet1, then display the adjacent number from column B.

Please help!!!

 

[Jon von der Heyden]

If the dates in Sheet1 column A are ordered ascending:
=IF(VLOOKUP(TODAY(),Sheet1!$A:$A,1,TRUE)=TODAY(),VLOOKUP(TODAY(),Sheet1!$A:$B,2,TRUE),NA())


if not ordered:
=VLOOKUP(TODAY(),Sheet1!$A:$B,2,FALSE)

 

[Kimmerz29]

Thank you very much

 

[shwetankbhardwaj]

Hi,

The below equation will not work in VBA. Right!

Could you please let me know if this task to be done by VBA, but I don't want to lookup any value. I need to find dates in column "A" (If A1) and copy adjacent values (names) from column "C" and "D" (C1 and D1).

Regards,
Shwetank

If the dates in Sheet1 column A are ordered ascending:
=IF(VLOOKUP(TODAY(),Sheet1!$A:$A,1,TRUE)=TODAY(),VLOOKUP(TODAY(),Sheet1!$A:$B,2,TRUE),NA())


if not ordered:
=VLOOKUP(TODAY(),Sheet1!$A:$B,2,FALSE)

"