I have two name ranges Flash445 and FlashCal and would like to reference them in a formula. I would like to use the Indirect formula and use a static "Flash" then reference a dynamic cell in A1 that can change from 445 or Cal. I'm sure it's a pretty easy formula but for the life of me cannot get anything to work. Any help would be greatly appreciated.