1 | name | label | label_left | latitude | longitude | elev. (ft) | elev. (m) | scale | status | color | url |
|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Mount Hood | Hood | 45.3736 | 121.6925°W | 11239 | 3426 | 1.81 | active | red | http://en.wikipedia.org/wiki/Mount_Hood | |
3 | Mount Jefferson | Jefferson | 44.6744 | 121.7978°W | 10497 | 3199 | 1.62 | dormant | yellow | http://en.wikipedia.org/wiki/Mount_Jefferson_oregon | |
4 | Three-Fingered Jack | 3FJ | 1 | 44.4783 | 121.8442°W | 7841 | 2390 | 0.96 | extinct | green | http://en.wikipedia.org/wiki/Three-Fingered_Jack |
5 | Mount Washington | Washington | 44.3325 | 121.8372°W | 7794 | 2376 | 0.95 | extinct | green | http://en.wikipedia.org/wiki/Mount_Washington_%28Oregon%29 | |
6 | South Sister | S Sister | 1 | 44.1036 | 121.7681°W | 10358 | 3157 | 1.59 | active | red | http://en.wikipedia.org/wiki/South_Sister |
7 | Diamond Peak | Diamond | 43.5206 | 122.1486°W | 8750 | 2667 | 1.19 | extinct | green | http://en.wikipedia.org/wiki/Diamond_Peak_%28Oregon%29 | |
8 | Mount Thielsen | Thielsen | 1 | 43.1531 | 122.0658°W | 9182 | 2799 | 1.30 | extinct | green | http://en.wikipedia.org/wiki/Mount_Thielsen |
9 | Mount Scott (Crater Lake) | Crater Lake | 42.923 | 122.0163°W | 8929 | 2722 | 1.23 | dormant | yellow | http://en.wikipedia.org/wiki/Crater_Lake | |
10 | Mount McLoughlin | McLoughlin | 42.445 | 122.3142°W | 9495 | 2894 | 1.37 | dormant | yellow | http://en.wikipedia.org/wiki/Mount_McLoughlin |
1 | status | color | |
|---|---|---|---|
2 | active | red | |
3 | dormant | yellow | |
4 | extinct | green | |
5 | |||
6 | This table can be accessed using a formula like this: | ||
7 | =VLOOKUP("active",colors!A:B,2,FALSE) |