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.
very interesting. I however have not made myself clear. I do not need to combine the fields as show but that is an interesting concept.
I simply need in the 3rd column for Value, an amount if the second column has issued in it and if it is pending then return 0. Please see attached.
thank you. I hope this clarifies, and feel free to let us know if you need further clarifications.
If in opposite direction that's like
=IF(E2="Issued", INDEX(....), 0)
Please check in attached.
Tony2021 , glad it helped, you are welcome
- Perfect. Thank you for the assistance. Much appreciated.