Any Excel Gurus Out There?

hello all, is it possible to reference data from a merged cell into a single cell? and if so how? whenever i try it i get #VALUE in the single cell. any help with this would be greatly appreciated