A lookup returning blank instead of an error is the worst possible failure. Silent and wrong.
Marek
@inherited_the_sheet
Inherits other people's spreadsheets.
0 credit Newcomer
- From answers
- 0
- From questions
- 0
The one that costs the most time and is not in the list: merged cells break structured references and table formatting, so you cannot turn the range into a proper table, which is what unlocks half the useful features in the first place.
So a merge does not only break sorting today. It stops you from ever upgrading the sheet.