J4=TEXT(6,"0.00")
then below
J5=TEXT(J4+0.1,"0.00")
E2=TEXT((DATEDIF(D2,$A$2,"y") & "." & DATEDIF(D2,$A$2,"ym")),"0.00")
no change in vlookup
=VLOOKUP(E3,Data!$J$3:$K$88,2,FALSE)
J4=TEXT(6,"0.00")
then below
J5=TEXT(J4+0.1,"0.00")
E2=TEXT((DATEDIF(D2,$A$2,"y") & "." & DATEDIF(D2,$A$2,"ym")),"0.00")
no change in vlookup
=VLOOKUP(E3,Data!$J$3:$K$88,2,FALSE)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks