![]() ![]() ![]() Or it fails with an error.Īside from winning the award for "Most Confusing Problem Statement" (please read comments from I think you want to match the PID/township values to a list in Sheet2. The output keeps either telling me "FALSE" or !VALUE#. ![]() B1:B9 is referencing the mapsheet list for survey township 02 (021-029).A1:A9 is referencing the mapsheet list for survey township (011-019).The survey township range (021-029) and the PLSS township (04S) output are my variables, which I will alter per county. The formula needs to refer to the list on sheet 2 and if the first 3 characters of the PID for survey township 2 are 021-029, the output for the township cell should be (04S) for township 4 South. The particular county has 20 survey townships. I created a reference list in sheet2 that lists every map sheet in the county (011-209). I'm now working on the township and range. Nine map sheets with 4 sections per sheet is the 36. There are 36 sections in a "survey township". However, each "survey township" falls within the grid of a single township and range square in the PLSS.Įach survey township is made up of 9 "map sheets" from the old days of milar map sheets which held 4 sections per map. However the "survey township" should not be confused with the township and range of the PLSS. The PID begins with the 3 digits of the survey township followed by the two section number digits. I'm running Office 2010 and I'm trying to build a function in Excel that derives the section, township and range from the 16 digit parcel identification number (PID) into individual columns. I am a GIS specialist for a cadastral mapping company. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |