Spreadsheet: 775439d1649099814-formula-to-return-first-value-xlookup-not-doing-the-job-example
Sheet: example

/Object/#id | /Object/Acquisition/Date/DateBegin | /Object/Acquisition/Date/DateEnd | /Object/Acquisition/Date/DateEnd/#agg | /Object/Acquisition/Method | /Object/Acquisition/Person/#id | /Object/Acquisition/Person/Address | /Object/Acquisition/Person/PersonName | /Object/Acquisition/Person/Role | /Object/Association/#id | /Object/Association/Date/DateBegin | /Object/Association/Date/DateEnd | /Object/Association/Person/#id | /Object/Association/Person/PersonName | /Object/Association/Place/#id | /Object/Association/Place/County | /Object/Association/Place/SiteName | /Object/Association/Type | /Object/Content/#id | /Object/Content/Date/DateBegin | /Object/Content/Date/DateEnd | /Object/Content/Place/#id | /Object/Description/#id | /Object/Description/Aspect/#id | /Object/Description/Aspect | /Object/Description/Aspect/Keyword | /Object/Description/Aspect/Keyword/Note | /Object/Description/Measurement/Dimension | /Object/Description/Measurement/Part | /Object/Description/Measurement/Reading | /Object/Description/Note | /Object/FieldCollection/Place/#id | /Object/Identification/BriefDescription | /Object/Identification/Classification/Keyword | /Object/Identification/Classification/System | /Object/Identification/ObjectName/#id | /Object/Identification/ObjectName/@elementtype | /Object/Identification/ObjectName/Keyword | /Object/Notes | /Object/ObjectIdentity/Number | /Object/ObjectLocation/#id | /Object/ObjectLocation/@elementtype | /Object/ObjectLocation/Location | /Object/OtherIdentity | /Object/OtherIdentity/@elementtype | /Object/Production/#id | /Object/Production/Date/DateBegin | /Object/Production/Date/DateEnd | /Object/Production/Period | /Object/Production/Person/#id | /Object/Production/Place/#id | /Object/Recorder/Date | /Object/Recorder/Initials | /Object/References/#id | /Object/Reproduction/#id | /Object/Reproduction/Filename/#id | /Object/Reproduction/Filename | /Object/Reproduction/Filename/CameraData | /Object/Reproduction/Filename/Date | /Object/Reproduction/Filename/ImageSize/Measurement/Dimension | /Object/Reproduction/Filename/ImageSize/Measurement/Reading | /Object/Reproduction/Filename/Time | /Object/Reproduction/SummaryText/@elementtype
203 | 3.6.1939 |  |  | gift | 205 |  | [NAME] | from |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1939.13
203 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Horse brass |  |  |  |  |  |  | 1939.13
203 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.542 | SHIC |  |  |  |  | 1939.13
203 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 405 | simple name | horse brass |  | 1939.13
203 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 406 | full name | horse brass |  | 1939.13
203 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | see 1994.61 | 1939.13
203 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1939.13 | 405 | home location
203 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1939.13 | 406 | current location | Unknown
203 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1939.13 |  |  |  | 922 | previous number
203 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1939.13 |  |  |  |  |  | 203 | 1850 | 1899 | 19th century, late
203 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1939.13 |  |  |  |  |  |  |  |  |  |  |  | 16.1.1992 | BB
237 | 1.3.1946 |  |  | gift | 239 |  | [NAME] | from |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1946.15
237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cart horse tassels |  |  |  |  |  |  | 1946.15
237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.5421 | SHIC |  |  |  |  | 1946.15
237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 473 | simple name | tassel |  | 1946.15
237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 474 | full name | cart horse tassels |  | 1946.15
237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | from local Saddlery | 1946.15
237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1946.15 | 473 | home location
237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1946.15 | 474 | current location | Unknown
237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1946.15 |  |  |  | 1039 | previous number
237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1946.15 |  |  |  |  |  | 237 | 1900 | 1929 | 20th century early
237 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1946.15 |  |  |  |  |  |  |  |  |  |  |  | 6.12.1991 | BB
386 | 5.1968 |  |  | gift | 388 | Orangevile & Ontario & Canada |  | from |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5
386 | 5.1968 |  |  | gift | 388 |  | Miss [NAME] | from |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  | 11 | 1785 | 1867 | 9 | [NAME] |  |  |  | owner |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  | 11 | 1785 | 1867 |  |  | 9 | [NAME] | West End | owner |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 354 | 1800 | 1834 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 82 | condition | fair | opening mended. Some holes |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 83 | completeness | incomplete | missing one ring |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 84 | material | textile | cotton |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 84 | material | metal |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 |  |  |  |  | length |  | 240mm |  |  |  |  |  |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 |  |  |  |  | width |  | 40mm (approx) |  |  |  |  |  |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 |  |  |  |  | diameter | ring | 17mm |  |  |  |  |  |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stocking purse. Knotted in vertical stripes of browns and blues |  |  |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.41 | SHIC |  |  |  |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 771 | simple name | purse |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 772 | full name | stocking purse |  | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stocking Purse knotted in vertical stripes of browns and blues Central lengthwise opening of 55mm Ring closure. For further history of family and association with donor, see entry 1972.9 in Catalogue of Exhibits | 1968.5
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5 | 771 | home location | Case P
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5 | 772 | current location | Case P
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5 |  |  |  |  | previous number
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5 |  |  |  |  |  | 386 | 1800 | 1834 | 19th century, early
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5 |  |  |  |  |  | 386 | 1800 | 1834 | 19th century, early
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5 |  |  |  |  |  | 386 | 1800 | 1834 | 19th century, early | 24
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5 |  |  |  |  |  | 386 | 1800 | 1834 | 19th century, early |  | 22
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5 |  |  |  |  |  |  |  |  |  |  |  | 7.4.1986 | AG
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 49 | 1968.5.jpg | NIKON CORPORATION; NIKON D3000; rotated 0°; shutter 1/0s; aperture f22; lens 22mm; | 13.2.2012 | resolution | 300 DPI | 20:46:54 | image caption
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 49 | 1968.5.jpg | NIKON CORPORATION; NIKON D3000; rotated 0°; shutter 1/0s; aperture f22; lens 22mm; | 13.2.2012 | width | 1500 pixels | 20:46:54 | image caption
386 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1968.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | 49 | 1968.5.jpg | NIKON CORPORATION; NIKON D3000; rotated 0°; shutter 1/0s; aperture f22; lens 22mm; | 13.2.2012 | height | 1200 pixels | 20:46:54 | image caption
442 | 9.1972 |  |  | gift | 444 |  | Mr S Platt | from |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  | 17 |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  | 17 |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 407 | 1800 | 1834 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 | 100 | condition | good |  |  |  |  | crocheted stocking purse in green and beige, with metal ' beads'. 2 closure rings. central lengthwise opening of 75mm. |  |  |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 | 101 | completeness | complete |  |  |  |  | crocheted stocking purse in green and beige, with metal ' beads'. 2 closure rings. central lengthwise opening of 75mm. |  |  |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 | 102 | material | textile | cotton |  |  |  | crocheted stocking purse in green and beige, with metal ' beads'. 2 closure rings. central lengthwise opening of 75mm. |  |  |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 | 102 | material | metal |  |  |  |  | crocheted stocking purse in green and beige, with metal ' beads'. 2 closure rings. central lengthwise opening of 75mm. |  |  |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63 |  |  |  |  | width |  | 65mm |  |  |  |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63 |  |  |  |  | length |  | 330mm |  |  |  |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63 |  |  |  |  | diameter | ring | 20mm |  |  |  |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stocking Purse |  |  |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.41 | SHIC |  |  |  |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 883 | simple name | purse |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 884 | full name | stocking purse |  | 1972.8
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8 | 883 | home location | Case P
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8 | 884 | current location | Case P
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8 |  |  |  |  | previous number
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8 |  |  |  |  |  | 442 | 1800 | 1834 | 19th century, early
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8 |  |  |  |  |  | 442 | 1800 | 1834 | 19th century, early
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8 |  |  |  |  |  | 442 | 1800 | 1834 | 19th century, early | 25
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8 |  |  |  |  |  | 442 | 1800 | 1834 | 19th century, early |  | 23
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8 |  |  |  |  |  |  |  |  |  |  |  | 7.4.1986 | AG
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 | 52 | 1972.8.jpg | NIKON CORPORATION; NIKON D3000; rotated 0°; shutter 1/0s; aperture f22; lens 22mm; | 13.2.2012 | resolution | 300 DPI | 20:37:08 | image caption
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 | 52 | 1972.8.jpg | NIKON CORPORATION; NIKON D3000; rotated 0°; shutter 1/0s; aperture f22; lens 22mm; | 13.2.2012 | width | 1500 pixels | 20:37:08 | image caption
442 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1972.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 | 52 | 1972.8.jpg | NIKON CORPORATION; NIKON D3000; rotated 0°; shutter 1/0s; aperture f22; lens 22mm; | 13.2.2012 | height | 1200 pixels | 20:37:08 | image caption