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: 438
        
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