Would love to help more, but we need more information. But again, I didn't have an example of the table. In which the following formula should get you what you want: =INDEX(Sheet2!$B$1:$B$19,MATCH(LEFT(B2,3),Sheet2!$A$1:$A$19,0))Īnd yes, tables can be your friend here (especially on Sheet2). Now, put the result you want for those values in column B. Instead of having these "groups" in separate columns, try putting all the possible values of the PID in column A (still Sheet2). 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 kommentar(er)
