Originally posted by LisaContractorUmbrella
View Post
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Reply to: Anyone feeling kind?
Collapse
You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
- You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
- You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
- If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Logging in...
Previously on "Anyone feeling kind?"
Collapse
-
Originally posted by BrilloPad View PostErr - how can I put this - the issue was between the chair and the keyboard....
Leave a comment:
-
Originally posted by oscarose View PostTrailing spaces?
Leave a comment:
-
Originally posted by BrilloPad View PostAll resolved now - I am an excel god!
Leave a comment:
-
All sorted - thanks for all the input guys and a big for Brillo who has just saved my sanity
Leave a comment:
-
Originally posted by oscarose View PostHave you reference locked your arrays?
Leave a comment:
-
Originally posted by LisaContractorUmbrella View PostRight tried that. I have come to the conclusion that it must be the data that's been imported that's causing the problem as a really simple Vlookup is not working in a completely new workbook. Some of the data is downloaded as a csv file from a banking system - do any of you know whether or not they would have built something in to stop the data being used???? Have tried =CLEAN(), =TRIM(), =LEN() and =ISNUMBER() on the data and everything seems to have worked - length is correct and number format is confirmed but am still getting #N/A
Leave a comment:
-
Right tried that. I have come to the conclusion that it must be the data that's been imported that's causing the problem as a really simple Vlookup is not working in a completely new workbook. Some of the data is downloaded as a csv file from a banking system - do any of you know whether or not they would have built something in to stop the data being used???? Have tried =CLEAN(), =TRIM(), =LEN() and =ISNUMBER() on the data and everything seems to have worked - length is correct and number format is confirmed but am still getting #N/A
Leave a comment:
-
Thanks guys - I'll give rebuilding it a go and see how I get on. The data on the various sheets is all imported from other programmes so I think you may be right that it has just thrown a wobbly
Leave a comment:
-
BlasterBates is probably right, sometimes a spreadsheet can go haywire when it's had data imported into it from elsewhere. I've seen it a few times and it's completely unpredictable.
Best bet is to start a brand new workbook, then copy and paste values from your broken sheet into a sheet in the new workbook. Then try a new lookup formula in the new workbook and see what happens.
You could also try making a new column in your existing sheet and fill it with =value(A2) (if Col A contains your lookup IDs) and paste down and then do the lookup on that column instead.
You could also try a combination of INDEX and MATCH instead of VLOOKUP.
Leave a comment:
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Leave a comment: