I would also like to know the answer to this. Bumping for interest.
This guy seems to have made a fancy-dancy material function to make it work, but doesn’t go into how he made it, or how I could use it:[UE4] World Aligned Texture/Normal with Rotation and offset. - YouTube
EDIT: Found the rest of his project, try this: Material Function - World Aligned Texture/Normal With offset & Rotation - Asset Creation - Epic Developer Community Forums