Forum Discussion
Structured reference does not work on merged cells
Hi, I have interesting issue in Excel, i will do my best to explain it thoroughlt. I have two Sheets: Sheet1 and Sheet2 On 1st Sheet2 I have table named Table1. I am trying to make ce...
It looks like a bug, but it's one more reason to avoid merging cells - they cause lots of problems.
As an alternative, select C12:D12, unmerge them, then set the horizontal alignment to Center Across Selection.
Select C12. When you create the VLOOKUP formula, Excel will use the structured reference to Table1.
- Yes, it looks like a bug to me aswell.
Thank you for your quick reply and suggestion!
