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.
That could be
=INDEX(Table1,
MATCH(A2,Table1[Beneficiary],0),
MATCH(TEXT(EOMONTH(TODAY(),-1)+1,"m/d/yyyy"),Table1[#Headers],0))