Excel sorting and vlookup help

Presupuesto $30 - $250 AUD
Ofertas 15
Oferta promedio $102
Estado Cerrado


I have a created an Excel spreadsheet with 3 tabs and I have created a 4th tab "consolidated view" that I want to sort on and then chart off. I'm having some issues with my consolidated view spreadsheet when I do a sort on a vlookup, I think I might have some slight gremlins in it. I don't think its complicated for a proficient Excel person.

I want to time box this activity, I'm also looking for generic "make it feel and work better" tips when someone is looking at it e.g., usability enhancements.

You must be skilled in Excel and be able to turn around a solution fast.


Obtén cotizaciones gratis para un proyecto como este

Este proyecto fue adjudicado a


Excellent person to work with again. Within a week, we hired him 2 times and done the work more than expected. Very humble person to hear the task and delivered more than expected.Would love to hire him again and recommend for everyone.
Acerca del freelancer
BAVarun Profile Picture

My team comes with a combined professional experience of over 13 years in the area of Business Analysis, report writing and Accounting. We carry various Business Analysis certifications from the organizations we've worked with. I'm currently working as Lead Business Analyst with one of the fortune 6 organizations and my another team member is working as Assistant Manager Finance with one of the Italy's largest retailers. I hold a Bachelors degree in Engineering and a Master of Business Administration degree in Information Technology. My team member is a Chartered Accountant with over 5 years of experience working with individuals, corporations and LLCs in many industries. We provide bookkeeping, accounting, tax and business advisory services If we undertake your project, you can rest be assured that you will get a high quality product. Beyond quality, I'm available for constant communication and updates on ongoing projects. We look forward to speaking with you soon.

¿Buscas ganar algo de dinero?

  • Establece tu presupuesto y el plazo
  • Describe tu propuesta
  • Recibe dinero por tu trabajo

Ofertas en este proyecto

  • Sharmakaran1992 Profile Picture
  • rinabuoy13 Profile Picture


    Kuala Lumpur,  Malaysia

    I am a engineer with experiences in numerical analysis, data mining, programming (VBA, c#), mathematics, optimisation etc. I have good record of delivering projects to satisfied clients here.

  • techwizards3 Profile Picture


    delhi,  India

    talented and experieExpert in Website Development ,Software Development, Mobile Dev., Web design, Smart Phone Development,SEO,3D, 4D,Ecommerce site Dev.,Flash, Flex, Logo, Banner, net,My Sql,Java, Opencart,Magento, Drupal,,PHP,ASP.net,Wordpress nced software developer

  • priyaranjanpawan Profile Picture



    I am Petroleum Engineer from Indian School of Mines Dhanbad. I have good programming skills. I am looking for interesting freelancing opportunity.

  • royalcalif Profile Picture


    Tiruchirappalli,  India

    RoyalCalif Techonologies is a registered firm based in India Offering a wide range of back office and Information Technology Enabled Services namely Data Entry Offline Data Entry Form Filling Data Entry using the given package Rapid and accurate keying from images of structured documents Online Data Entry Email Handling Semi Automated Data Conversion Data Entry in Shopping Cart and Maintenance Video uploading Graphic Design o Logo Design, Icons, etc., o Layout for websites o Picture Editing etc., Web Development o Website Designing (layouts, static pages, CSS) o Website Applications (Dynamic pages, Registration form, shopping cart, User control panel to maintain website content, etc.,) o Website Maintenance (bug free, email assistance, etc.,) Search Engine Optimization Web Promotions

  • cquintero Profile Picture


    Maracay,  Venezuela

    After more than 10 years of experience working in companies, developing software, web applications, database management, project management and system maintenance. I made the big decision to become freelancers and create a small team to develop our own ideas and those of others in search of something new, better and be able to improve life in general.

  • felixvitangcol Profile Picture


    Marikina City,  Philippines

    I'm a Mining Engineering student, looking for other opportunities to enhance my skills and be able to help others achieve specified tasks.

  • MohsanEijaz Profile Picture


    RAWALPINDI,  Pakistan

    I am very hardworking and can work effectively as fast as I can. I have excellent skills in HTML5, CSS3, JS, AJAX, JQYERY, , , BOOTSTRAP, PHP,Wordpress, , MVC, Web Research and Microsoft Office and I have enough experience with different kinds of tasks as you can see in my "Work History", most of the time I gave my clients a great results.I have fast internet connection at home, have my own pc to use anytime and have own space to work. I can work fulltime and will focus to this project. I can follow instructions very well and will deliver the project on time. It is a pleasure if ever you will message me for an interview. I can work as soon as possible. ************ I have also experience in MS Excel, VBA Programming, XML, MS Work, Google Docs, SEO, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications and expertise and 5 years experience in JAVASCRIPT, HTML5, CSS3, AJAX, JQYERY, AngularJS, BOOTSTRAP, C#, , JAVA, WORDPRESS, PHP, other related tools

  • sushilpanthri Profile Picture


    Delhi,  India

    Seeking legitimate online part time, flexible work only, no money constraint. Brief expertise includes :- - Data Entry Specialist - Mastery in Excel & MIS/Reports - Data Analyst & General Accounting - Web Search & Online Marketing - Microsoft Office Suite

  • giantr Profile Picture


    United States

    Hiring a very professional and experienced Financial Analyst has never been so easy. After my time at a top US university with a triple major in finance, economics, and philosophy, I began working as an analyst for a multibillion-dollar company. There I was expected to develop, manipulate, and analyze extremely complex Excel workbooks and create presentations for the CFO. This experience gave me the skills to communicate effectively, listen to needs, and work under pressure. I'm a conscientious worker with a focus on quality and client satisfaction. I support requests even after projects are formally closed. I will exceed your expectations. My values - honesty, efficiency, communication, responsibility, and target orientation - will ensure that our project will exceed your expectations. Skills: - Expert on: Excel, STATA, PowerPoint - Dashboards - Power Pivot - Data Entry - PDF to Excel or Word - Data Processing - Automation Report Excel via VBA macro Best regards, Giantr