Excel - Referring to a certain cell based off of data in another
Posted
by
Ethan Brouwer
on Super User
See other posts from Super User
or by Ethan Brouwer
Published on 2013-10-21T14:50:35Z
Indexed on
2013/10/21
15:58 UTC
Read the original article
Hit count: 370
I have a spreadsheet where there is one table with the headings:
Coordinate, Lat, Long
Another with headings
Triangle, Coordinate 1, Coordinate 2, Coordinate 3, Area
What this is for, is taking the triangles formed by the specified three coordinates' area based off of Girard's theorem, as they are all spherical triangles. I need to take the specific latitude and longitude values from the first table based on the coordinate numbers underneath the three coordinate headings in the second table. I hope this makes sense. Here are pictures detailing what the two tables look like:
Table 1
Table 2
Thanks in advance. And I really do hope this makes sense.
© Super User or respective owner