The Numbers method, using comments as Barry showed, is probably the best method. An alternate method which is more complex would be to use an Applescript running in the background. The Applescript can scan in the background for which cell/column is currently selected and write that cell/column address into a cell in your table. A formula in your table (most likely a lookup formula) can use that address to serve up the correct help text in a diffrerent cell in the table or in another table.
Some problems with this methodare
- The script is not part of the document. It is a separate entity.
- The script must be started manually. It will not automatically start when the Numbers document is opened.
- If the Numbers document is to be used on other Macs, each would also need the script installed.