In col-A ,I have dates entered in ascending order.
in Col-B,I have some blank cells and some entries in them.
I am trying to do this:
if(isblank(Vlookup(currentmonth date
entry/entries,A2:B100,1,false),print"done","not done")
in otherwords:
find all current month date or dates in Col- A,match corresponding values in
Col-B,and if any corresponnding value in Col-b is is not blank print
somethingin Col-c.
If there are no current month date entry/entries print something else in
Col-c- last blank available cell.
Any function or formula ?