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

/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 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Horse brass | 4.542 | SHIC | 405 | simple name | horse brass | see 1994.61 | 1939.13 | 405 | home location |  | 922 | previous number | 203 | 1850 | 1899 | 19th century, late |  |  | 16.1.1992 | BB
237 | 1.3.1946 |  |  | gift | 239 |  | [NAME] | from |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cart horse tassels | 4.5421 | SHIC | 473 | simple name | tassel |  | 1946.15 | 473 | home location |  | 1039 | previous number | 237 | 1900 | 1929 | 20th century early |  |  | 6.12.1991 | BB
386 | 5.1968 |  |  | gift | 388 | Orangevile & Ontario & Canada | Miss [NAME] | from | 11 | 1785 | 1867 | 9 | [NAME] | 9 | [NAME] | West End | owner | 354 | 1800 | 1834 |  | 50 | 82 | condition | fair | opening mended. Some holes | length |  | 240mm |  |  | Stocking purse. Knotted in vertical stripes of browns and blues | 3.41 | SHIC | 771 | simple name | purse | 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 | 771 | home location | Case P |  | previous number | 386 | 1800 | 1834 | 19th century, early | 24 | 22 | 7.4.1986 | AG |  | 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
442 | 9.1972 |  |  | gift | 444 |  | Mr S Platt | from |  |  |  |  |  | 15 |  |  |  | 407 | 1800 | 1834 |  | 62 | 100 | condition | good | cotton | width | ring | 65mm | crocheted stocking purse in green and beige, with metal ' beads'. 2 closure rings. central lengthwise opening of 75mm. | 9 | Stocking Purse | 3.41 | SHIC | 883 | simple name | purse |  | 1972.8 | 883 | home location | Case P |  | previous number | 442 | 1800 | 1834 | 19th century, early | 25 | 23 | 7.4.1986 | AG | 3 | 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
203
237
386
442