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 1

Table 2

Table 2

Thanks in advance. And I really do hope this makes sense.

© Super User or respective owner

Related posts about microsoft-excel

Related posts about function