Array like syntax in MS Excel

Array like syntax in MS Excel How can I select a cell using subscript like in most programming languages - a[x]?
Asked by: Guest \| Views: 190

Total answers/comments: 2

Comments display order:

Guest [Entry]

"Use the INDIRECT function:

=INDIRECT(""A""&C2)

if C2 is the cell that contains the row number .

You can use this in your IF formula:

= IF(INDIRECT(""A""&C2) = ""X""; TRUE; FALSE)"

Guest [Entry]

"You could try

=if(A & trim(text(something that evaluates to a number))=""X"",true,false)

I guess, if you could be a bit more specific with how your getting row() it would be helpful."