Copy (=) data from a merged cell into an unmerged cell

[FireBott]

Hi All. I am stumped and would appreciate some help. I have two sheets Project sheet and Summary sheet. Within the PROJECT sheet, I have a cell(s) that are merged (B19:H19). In the SUMMARY sheet I have a non-merged cell (J6) where I want to copy the data from the PROJECTS sheet (B19:H19) to the SUMMARY sheet (J6). When I type in = then go to the PROJECT sheet and select the merged cells, the return is zeros. Here is an example using the BD-Integrations PROJECT SHEET.

I feel I am above the intermediate level of excel understanding, so this one has me stumped. Does anyone know why this is happening and what the fix would be. I have googled and search through this forum with no results.

Thanks in advance.

FireBott

 

[Snakehips]

@FireBott Try just referencing the merged cell by it's top left cell.

='BD-Integhrations'!B19

 

[FireBott]

Hi @Snakehips. Thanks for the response. I tried your suggestion and it returns this. However, the row a few rows down returns the right value