When reference column changes, all lookups are automatically refreshed on the screen, without a need to press Refresh.
See the picture. Note how Exchange Rate recalculates after changing the currency. And, of course, Amount USD is also changed, because of Exchange Rate.
