Spreadsheet: 783222d1654677217-using-if-formula-to-match-against-different-codes-example-data-table-match-data
Sheet: REMOVED

 | Division | Cost Code | Site Name | City | County | Postcode | Region | Country | Role | [NAME] (Determined by No Sites Bid For) | [NAME] (All Are Now PSL) | [NAME] | Supplier Aspire Code | [NAME] | Telephone Number | OOH Email Address | OOH Telephone Number
 | AdultCare | A74 | Apple Mews CM | [NAME] | County Armagh | BT61 8AR | N Ireland | Northern Ireland | Care Support Worker (P63) | LOCAL (Less than 30 Services) | New Supplier | Connected Health | SACONN05 | [EMAIL] | [PHONE] | [EMAIL] | [PHONE]
 | AdultCare | A74 | Apple Mews CM | [NAME] | County Armagh | BT61 8AR | N Ireland | Northern Ireland | Nurse (P13) | LOCAL (Less than 30 Services) | New Supplier | Connected Health | SACONN05 | [EMAIL] | [PHONE] | [EMAIL] | [PHONE]
 | AdultCare | A77 | Loughshore | Newtownabbey | [NAME] | BT37 0PR | N Ireland | Northern Ireland | Healthcare Assistant (P16) | LOCAL (Less than 30 Services) | New Supplier | Connected Health | SACONN05 | [EMAIL] | [PHONE] | [EMAIL] | [PHONE]
 | AdultCare | A76 | River House LD | Belfast | [NAME] | BT8 7XP | N Ireland | Northern Ireland | Care Support Worker (P63) | LOCAL (Less than 30 Services) | New Supplier | Connected Health | SACONN05 | [EMAIL] | [PHONE] | [EMAIL] | [PHONE]
 | AdultCare | B65 | [NAME] | Newtownabbey | [NAME] | BT37 0PR | N Ireland | Northern Ireland | Care Support Worker (P63) | LOCAL (Less than 30 Services) | New Supplier | Connected Health | SACONN05 | [EMAIL] | [PHONE] | [EMAIL] | [PHONE]
 | AdultCare | B65 | [NAME] | Newtownabbey | [NAME] | BT37 0PR | N Ireland | Northern Ireland | Nurse (P13) | NATIONAL (100+ Services) | New Supplier | Connected Health | SACONN05 | [EMAIL] | [PHONE] | [EMAIL] | [PHONE]
 | AdultCare | 877 | Bannister Farm | Leyland | Lancashire | PR26 7TB | North West | England | Care Support Worker (P63) | LOCAL (Less than 30 Services) | Existing Supplier | [NAME] | SAKARE26 | [EMAIL] | 01772 367656 | [EMAIL] | 01772 367656
 | AdultCare | A90 | Dixons Farm PC | Preston | Lancashire | PR5 6AS | North West | England | Care Support Worker (P63) | LOCAL (Less than 30 Services) | Existing Supplier | [NAME] | SAKARE26 | [EMAIL] | 01772 367656 | [EMAIL] | 01772 367656
 | AdultCare | A72 | [NAME] | Preston | Lancashire | PR5 4ED | North West | England | Care Support Worker (P63) | LOCAL (Less than 30 Services) | Existing Supplier | [NAME] | SAKARE26 | [EMAIL] | 01772 367656 | [EMAIL] | 01772 367656
 | AdultCare | A89 | Oaks, The PC | Preston | Lancashire | PR5 4LE | North West | England | Care Support Worker (P63) | LOCAL (Less than 30 Services) | Existing Supplier | [NAME] | SAKARE26 | [EMAIL] | 01772 367656 | [EMAIL] | 01772 367656
 | AdultCare | [NAME] | The Bungalow PC | Preston | Lancashire | PR5 5UR | North West | England | Care Support Worker (P63) | LOCAL (Less than 30 Services) | Existing Supplier | [NAME] | SAKARE26 | [EMAIL] | 01772 367656 | [EMAIL] | 01772 367656
 | AdultCare | 875 | Tree Top View | Leyland | Lancashire | PR26 7TB | North West | England | Care Support Worker (P63) | LOCAL (Less than 30 Services) | Existing Supplier | [NAME] | SAKARE26 | [EMAIL] | 01772 367656 | [EMAIL] | 01772 367656
 | AdultCare | A86 | Woodlands PC | Preston | Lancashire | PR5 6AQ | North West | England | Care Support Worker (P63) | LOCAL (Less than 30 Services) | Existing Supplier | [NAME] | SAKARE26 | [EMAIL] | 01772 367656 | [EMAIL] | 01772 367656
 | AdultCare | 956 | [NAME] | Preston | Lancashire | PR2 9SX | North West | England | Healthcare Assistant (P16) | LOCAL (Less than 30 Services) | Existing Supplier | [NAME] | SAKARE26 | [EMAIL] | 01772 367656 | [EMAIL] | 01772 367656
 | Healthcare | 313 | Preston, The Priory Hospital | Preston | Lancashire | PR4 0HB | North West | England | Healthcare Assistant (P16) | LOCAL (Less than 30 Services) | Existing Supplier | [NAME] | SAKARE26 | [EMAIL] | 01772 367656 | [EMAIL] | 01772 367656
 | Healthcare | 313 | Preston, The Priory Hospital | Preston | Lancashire | PR4 0HB | North West | England | Nurse (P13) | LOCAL (Less than 30 Services) | Existing Supplier | [NAME] | SAKARE26 | [EMAIL] | 01772 367656 | [EMAIL] | 01772 367656