I want to perform above mentioned task in libreoffice calc or in openoffice calc. In microsoft excel it is possible by using match, index and most importantly in formulas menu, using display names option. I found one file in previous answer (named lights.dos) but it does not work. It contains macro and macro error appear. Can anybod help ?
When you mention anything (external program behavior/existing solutions (however broken)/etc), please always link to relevant topics or attach relevant files. E.g., here you would do great if edited your question and provided links to (1) Excel documentation on “display names option”, and (2), a link to "previous answer " or attached “named lights.dos”.
Since i just joined yesterday, please pardon my ignorence.
Please pay attention to what I asked you: that you edit your question, not “answer” yourself with what is not an answer to your own question. Every Answer here should only answer originally asked question, not clarify questions or ask something different.