It possible with a bit of a hack (as
position: sticky; seems to work oddly and requires a custom CSS).
So basically you have to have two navbars, one fixed (and initially moved up 100%) and the second with absolute position on the bottom of the section.
Then it's all to scroll interactions which affect different elements – note that scrolls into and out-of-view are given in pixels and translations are with 0ms.
Please check the preview as it's easier do see it yourself than to explain
Also here you should be able to clone it https://webflow.com/website/navtest-3ea789
Hope I helped!