KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I try to avoid using Excel too much, but when I do I like using structured references as they seem a lot cleaner to write. If I create a table called "table1" with columns "col1" and "col2" how would I reference the first row in "col1" using a structured reference in another table? I have tried the syntax =table1[[#this row],[col1]] , and just get an error. Is there a syntax like =table1[1,1] or =table1[1,[col1]] ? Of course, this doesn't work either, but what's the equivalent? It's very annoying, as it seems like this should be simple.
Tags (comma-separated)
Save Edits
Cancel