VLOOKUP and 256 characters limit
Many functions in EXCEL for MAC 2011 don't work at all (they return the dreaded #VALUE field) if the one of the reference cells has more than 256 characters. This is the case already for VLOOKUP, and for TEXT. Possibly for others as well?
Users shall have a list of these, to avoid disappointment. Of course if it could be corrected it would be better.
- Corrected by increasing the character length past 256, or
- Making the fact that the cell has more the 256 characters being the problem easier to realise!