so, i have two sheets.
one of them with a bunch of entries by date.
on the second one i want a formula to pick the last entry before date on another cell.
what i've got so far is: =index(sheet1!A:A;if(and(sheet1A:A<=G2;sheet1!A:A<>"");max(sheet1!A:A<>"")*(LIN(sheet1!A:A))))
the problem with this formula is that its showing all entries not empty in a list (instead only the last result) and also showing results above the date set on G2
i think there might be a even better formula for what I want... although this method should work...
cells in sheet1!A:A are dates, as well as data in G2.
Thanks in advance!
Bookmarks