@Peter Bartholomew @mtarler Thanks for your thoughtfull comments.
Actually, I didn't ask this capability in the context of LAMBDA or for loop. As a general exploration of the LET function (I am really new to almost all Office365 new excel functions) I was trying to reassign a name (treating it as variable) that was supposed to be final evaluation/calculation. Instead of creating many names to hold intermediate values I was trying to modify same name that was finally to be returned to reduce number of names. Step by step multiple reassignment(modification) was required as a result of parsing some moderately complex text string. And that's how I was stuck as LET does not allow reassignment of same name. My case was very specific use case and I know I could avoid reassignment with a different approach. But somehow I still wonder if for many other use cases we may encounter such requirement. Having said that I do agree that using same name for assignment of different logical value just to minimize number of names is truly a bad practice and may reduce code readability. I guess, to guard against such bad practice, probably, team has restricted this reassignment capability. Thanks