Spreadsheet: 210891d1359589548-search-engine-for-excel-do-not-display-results-initially-ef209-test2
Sheet: Search

 | Sheet: | DATA |  |  | Sheet to search through: |  | Postcode fragment: |  |  |  | Sheets | [NAME]
 |  |  |  |  |  |  |  |  |  |  | DATA | 0
Row | List | Description | Day | Site_PCode | Site_Name | Site_Addr1 | Site_Addr2 | Site_Addr3 | Site_Addr4 |  |  | 15 | [NAME]
4 | 280 | KX05UWF | Saturday | BA1 5TJ | HARE AND HOUNDS (LANSDOWN) | LANDSDOWN |  | bath
5 | 280 | KX05UWF | Saturday | BA1 2LS | TOPLAND (ROYAL CRESCENT HOTEL) | 15-16 ROYAL CRESCENT HOTEL |  | BATH |  |  |  |  | A | IF(ISERROR(MATCH(ROWS($1:1),INDIRECT("'"&B4&"'!A:A"),0)),"-",MATCH(ROWS($1:1),INDIRECT("'"&B4&"'!A:A"),0))
6 | 280 | KX05UWF | Saturday | BA1 2LS | TOPLAND (ROYAL CRESCENT HOTEL) | 15-16 ROYAL CRESCENT HOTEL |  | BATH |  |  |  |  | B | IF(ROWS($1:1)>$N$3,"",IF($H$1<>"",$H$1,INDEX(Sheets,[NAME]:N$6))))
7 | 284 | HX05KYB | Tuesday | BS16 6RX | SPAR STORE | 32 WESTBOURNE ROAD | DOWNEND | BRISTOL | AVON |  |  |  | C | IF(OR($A4="-",$A4=""),"",IF(INDEX(INDIRECT("'"&$D$1&"'!B:B"),$A4)="","",INDEX(INDIRECT("'"&$D$1&"'!B:B"),$A4)))
8 | 284 | HX05KYB | Tuesday | BA1 2LS | TOPLAND (ROYAL CRESCENT HOTEL) | 15-16 ROYAL CRESCENT HOTEL |  | BATH |  |  |  |  | D | IF(OR($A4="-",$A4=""),"",IF(INDEX(INDIRECT("'"&$D$1&"'!C:[NAME]:C"),$A4)))
9 | 284 | HX05KYB | Tuesday | BA1 3JL | TOOLSTATION | UNIT 1 THE MALTINGS | BRASSMILL LANE | BATH | AVON |  |  |  | E | IF(OR($A4="-",$A4=""),"",IF(INDEX(INDIRECT("'"&$D$1&"'!D:D"),$A4)="","",INDEX(INDIRECT("'"&$D$1&"'!D:D"),$A4)))
10 | 284 | HX05KYB | Tuesday | BS16 3BA | BHUJON RESTAURANT LTD | 615 FISHPONDS ROAD | FISHPONDS | BRISTOL |  |  |  |  | F | IF(OR($A4="-",$A4=""),"",IF(INDEX(INDIRECT("'"&$D$1&"'!E:E"),$A4)="","",INDEX(INDIRECT("'"&$D$1&"'!E:E"),$A4)))
11 | 284 | HX05KYB | Tuesday | BS16 2NN | LLOYDS PHARMACY | 40 LANAWAY ROAD | OLDBURY COURT. FISHPONDS | [NAME] |  |  |  |  | G | IF(OR($A4="-",$A4=""),"",IF(INDEX(INDIRECT("'"&$D$1&"'!F:F"),$A4)="","",INDEX(INDIRECT("'"&$D$1&"'!F:F"),$A4)))
12 | 284 | HX05KYB | Tuesday | BS15 8JP | KINGSWOOD AUTOPART LTD | 2-6 REGENT STREET | KINGSWOOD | BRISTOL |  |  |  |  | H | IF(OR($A4="-",$A4=""),"",IF(INDEX(INDIRECT("'"&$D$1&"'!G:G"),$A4)="","",INDEX(INDIRECT("'"&$D$1&"'!G:G"),$A4)))
13 | 284 | HX05KYB | Tuesday | BS16 5PJ | PROVIDENT FINANCIAL | SOUTH VIEW BUSINESS PARK | 26 SOUTH VIEW | BRISTOL | AVON |  |  |  | I | IF(OR($A4="-",$A4=""),"",IF(INDEX(INDIRECT("'"&$D$1&"'!H:H"),$A4)="","",INDEX(INDIRECT("'"&$D$1&"'!H:H"),$A4)))
14 | 284 | HX05KYB | Tuesday | BS16 5FJ | LLOYDS PHARMACY | THE WILLOW SURGERY HILL HOUSE | ROAD DOWNEND | BRISTOL | AVON |  |  |  | J | IF(OR($A4="-",$A4=""),"",IF(INDEX(INDIRECT("'"&$D$1&"'!I:I"),$A4)="","",INDEX(INDIRECT("'"&$D$1&"'!I:I"),$A4)))
15 | 285 | HX05KYB | Wednesday | BA1 1LT | BATH & NORTH EAST SOMERSET COUNCIL | ABBEY CHAMBERS | [NAME], KINGSTON BUI | BATH | AVON |  |  |  | K | IF(OR($A4="-",$A4=""),"",IF(INDEX(INDIRECT("'"&$D$1&"'!J:J"),$A4)="","",INDEX(INDIRECT("'"&$D$1&"'!J:J"),$A4)))
16 | 285 | HX05KYB | Wednesday | BS15 9LA | WISHING WELL | WISHING WELL KINGSWOOD - BS15 9LA | KINGSWOOD ASPECTS LEISURE PARK | KINGSWOOD | BRISTOL
17 | 285 | HX05KYB | Wednesday | BS16 3JB | MACPHERSON AND COLBURN LTD | 48-60 LODGECAUSEWAY | FISHPONDS | BRISTOL
18 | 285 | HX05KYB | Wednesday | BA2 1DB | WILLIAM HILL - TWERTON | UNIT 2 109 HIGH STREET | TWERTON | BATH
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-