babypink2807
New Member
- Joined
- Jul 13, 2015
- Messages
- 42
- Office Version
- 2016
I have been at this all day, and embarrased about it and so frustrated. All I want is for the Vlookup to pull through a street address on another sheet. To start with the formula was showing as text, wold not show the value. Then for whatever reason my spreadsheet kept changing from Letter Column Headings to Numbers, dont know why it just did. I then found that I could not copy and paste from the original spreadsheet to a brand new one, again dont ask me why. I closed everything down and back up again. managed to coy and paste my data in to a brand new spreadsheet. My formula still will not pull through the street address. Please can someone help me. All day I have been trying and I cant type in 2750 street addresses, its just too much
Please help
Please help
| Book2.xlsx | ||||||||
|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | |||
| 1 | Account ID No | Street | First Name | Surname | Company Name | Building Name | ||
| 2 | ACT10 | #N/A | Andrew | Vaughan | W A & C M Vaughan | High Dovecote | ||
| 3 | ACT1000 | #N/A | James | Blanchard | Blanchard Enterprises | New House Farm | ||
| 4 | ACT1003 | #N/A | David | Leigh | Birchwood Park Farms | Birchwood Park Farm | ||
| 5 | ACT1004 | #N/A | B | Mycock | Birchwood Park Farms | Birchwood Park Farm | ||
| 6 | ACT1005 | #N/A | Gene | Fisher | Best Grass Ltd | Fishers Farm | ||
| 7 | ACT1006 | #N/A | R & J | Dymond | Battledown Contractors | Battledown Farm | ||
| 8 | ACT1007 | #N/A | Caroline | Bateman | Bateman Rural Associates | |||
| 9 | ACT1008 | #N/A | Toby | Bateman | Bateman Rural Associates | |||
| 10 | ACT1010 | #N/A | Robert | Ballie | Ballie Haylage | Ivy House | ||
| 11 | ACT1014 | #N/A | Brian | Jones | B T Jones | Fields Farm | ||
| 12 | ACT1016 | #N/A | Rob | Singleton | B J Singleton (Alresford) | Ranscombe Farm | ||
| 13 | ACT1017 | #N/A | Lawrence | Rich | B G & L D Rich | Stud Farm | ||
| 14 | ACT1019 | #N/A | Mark | Edwards | B C & D J Edwards & Son | Pool Farm | ||
| 15 | ACT1020 | #N/A | Joe | Lopez | B B Grounds Care Ltd | Frieze Hall Farm | ||
| 16 | ACT1021 | #N/A | Brian | Scott | B & B Scott | Odmoston Farm | ||
| 17 | ACT1022 | #N/A | Sarah | Brown | Avoncrook Farmers | Avoncrook Cottage | ||
| 18 | ACT1024 | #N/A | Richard | Burrough | Ashbridge Countryside Services | Manor Farm | ||
| 19 | ACT1025 | #N/A | John | Scott | Artemis Lane & Agriculture Ltd | Crouchlands | ||
| 20 | ACT1026 | #N/A | Owen | Hutchinson | Arrowcruit Limited | White House Farm | ||
| 21 | ACT1027 | #N/A | Paul | Apps | Apps Grab Hire | The Bungalow | ||
| 22 | ACT1029 | #N/A | Andy | Ball | Andy Ball Contractors | Hensbury Farm | ||
| 23 | ACT1031 | #N/A | Andrew | Baillie | Andrew Baillie & Son | Blackdub Farm | ||
| 24 | ACT10324 | #N/A | Stewart | Sinclair | Stewart Sinclair | |||
| 25 | ACT1035 | #N/A | Allen | James | Allen James Hay & Straw | Wessex Farm | ||
| 26 | ACT1036 | #N/A | Allan | Wilson | Allan W J Wilson | |||
| 27 | ACT1039 | #N/A | Simon | Corner | Aequus Land Ltd | Malt House | ||
| 28 | ACT104 | #N/A | William | Stratton | Stratton Contracting | Siabost Tillygreig | ||
| 29 | ACT1040 | #N/A | John | Adams | Adams Farm Ltd | |||
| 30 | ACT1042 | #N/A | Alun | Glyn Jones | Acton Farming Company | Meadowend Farm | ||
| 31 | ACT1043 | #N/A | Andrew | Smith | A W Smith & Sons | Home Farm | ||
| 32 | ACT1046 | #N/A | A | Dunn | A T & A Dunn | Newham Barton Farm | ||
| 33 | ACT1047 | #N/A | Ben | Coles | A S Coles & Son | Park Farm | ||
Sheet1 | ||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| B2:B33 | B2 | =VLOOKUP(A2,Sheet2!A2:S2757,2,FALSE) |
