I am trying to lock a cell from updating after updating once. Basically I have a function looking if a number exsits on another sheet and if it doesn't it puts the date in the desired cell however once it is in the cell I do not want the date to change again
I am not sure if this is a formatting cell issue or if it is a formula my formula looks like this so far
=IF(AND(IFNA(VLOOKUP(A2,Input!B2:M51,1,FALSE)<>"",1)=1,A2<>""),TODAY(),"")
Any help would be greatly appreciated
Bookmarks