Menu
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.
529
A reference within the text to a table, graph, diagram, etc. taken from a source should include the author, date and page number in brackets to enable the reader to identify the data. If you have already named the author in the text, only the publication year and page number needs to be mentioned in brackets.
Reference Multiple Separate Columns You simply reference each column separately and put a comma between the references.
try
=INDEX(col1,1)
you can even address cells in a 2-dim table, using
=INDEX(reference,row_num,column_num)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
