Forum Discussion
Solved
Vlookup with Today()
Hello Experts, I need a lookup that will return a value based on todays date. The tricky part is that my table is in month and year format and not days. Also, I think having the dates in ro...
If in opposite direction that's like
=IF(E2="Issued", INDEX(....), 0)
Please check in attached.
I might set the defined name 'today' to refer to
=(TEXT(EOMONTH(TODAY(),-1)+1, "m/d/yyyy"))
then perform an exact match on the table
= XLOOKUP( today, Table1[#Headers], Table1)
or the equivalent in old Excel.