How To Lookup fields from Child to Parent under certain condition

I know this has been answer many times but not finding the exact post/article to get this working. Parent Record = Opportunity Child Record = System System can have multiple "stages" or even mu...