the last cell in column K (the column & row that contains the cell with the data I need) is formated as "custom" in this format: "m/d/yyyy h:mm"
It does what I need it to do (my formula) like this:
="last updated on "&TEXT(CHANGE_LOG!K943,"mmmm dd yyyy")
But instead of "K943", I need the formula to use something like LOOKUP or INDEX to return the last row in column K... i've almost got it to work, but not quite and I'm tired of trying so I thought I'd ask here.
this is the last cell in Column K, and how its formatted:
It does what I need it to do (my formula) like this:
="last updated on "&TEXT(CHANGE_LOG!K943,"mmmm dd yyyy")
But instead of "K943", I need the formula to use something like LOOKUP or INDEX to return the last row in column K... i've almost got it to work, but not quite and I'm tired of trying so I thought I'd ask here.
this is the last cell in Column K, and how its formatted: