Thread: [Solved] How to use arrays?
View Single Post
 
Old 09-03-2016, 02:32 AM
Simplifier Simplifier is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Sep 2016
Posts: 1
Simplifier is on a distinguished road
Question How to use arrays?

Hello. I have computed value and want to display some description about it. There are a few values possible. Array sound good, but I don't know about arrays in Excel. I tried:

=INDEX({"a";"b";"c"};0;2)

Should give me c, but throws address error.

BTW: Different languages version have localized function names. Is possible change it? For example to use only English names?
Reply With Quote