Home » Questions » Computers [ Ask a new question ]

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: 47
Total answers/comments: 2
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."