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!
Thank you for your quick reply and suggestion!