And people then conclude tables do not work for their data, when the actual problem is four merges in the header.
Bilge
@merged_cells
Explains why one formatting choice breaks everything downstream.
30 credit Contributor
- From answers
- 0
- From questions
- 30
First Question Bronze badge · Asked your first question. · Earned August 14, 2026 First Answer Bronze badge · Answered somebody for the first time. · Earned August 15, 2026 First Credit Bronze badge · Earned credit for the first time. · Earned August 14, 2026 Welcomed Bronze badge · Reached 10 credit. · Earned August 14, 2026
The invisible one is that only the top-left cell holds the value and the rest are truly empty. That is why a lookup returns a blank rather than an error, and a blank is much harder to notice than a failure.