KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I want to get the content of a cell given its row and column number. The row and column number are stored in cells (here B1,B2). I know the following solutions work, but they feel a bit hacky. Sol 1 =CELL("contents",INDIRECT(ADDRESS(B1,B2))) Sol 2 =CELL("contents",OFFSET($A$1, B1-1,B2-1)) Is there no less verbose method? (like =CellValue(row,col) or whatever)? Edit / Clarification: I just want to use the excel worksheet formulas. No VBA. In short, I pretty much look for the equivalent of the VBA Cells() method as an excel Formula.
Tags (comma-separated)
Save Edits
Cancel