Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Categories
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media
Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

Create an advanced Excel lookup formula

$15
Delivery in
1 day
Rating
100%
(2 reviews)

  • Views 166
  • Sales 1
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
Show more details »

Explore the marketplace!

vlookup tables
    Help you with your MS Excel problem, formula(s), or task
    • Rating: 99%
    • Sold: 106
    Help you with your MS Excel problem, formula(s), or task
    $25
    Ali
    Ali S. United Kingdom
    View
    or contact
    • Delivery in 2 days
    • Sales 106
    • Rating 99%
    V-lookup/ H-lookup / Sumif only
    • Rating: 80%
    • Sold: 1
    V-lookup/ H-lookup / Sumif only
    $10
    HUMAYOON
    HUMAYOON S. Pakistan
    View
    or contact
    • Delivery in 1 day
    • Sales 1
    • Rating 80%
    Provide vlookup formula to ease task in excel.
    Provide vlookup formula to ease task in excel.
    $15
    Savita
    Savita R. India
    View
    or contact
    • Delivery in 1 day
    Create modify or fix formulas in Excel
    • Rating: 100%
    • Sold: 2
    Create modify or fix formulas in Excel
    $15
    Muhammad Barkat
    Muhammad Barkat H. Pakistan
    View
    or contact
    • Delivery in 1 day
    • Sales 2
    • Rating 100%
    Perform excel expert jobs
    Perform excel expert jobs
    $25
    Pranay kumar
    Pranay kumar G. India
    View
    or contact
    • Delivery in 2 days
    Professional Customized Spreadsheet VBA
    • Sold: 1
    Professional Customized Spreadsheet VBA
    $20
    Md Zahedul
    Md Zahedul I. United States
    View
    or contact
    • Delivery in 2 days
    • Sales 1
   

What you get with this Offer

If you're not a regular user of Excel it can be tricky to work out how to look up a corresponding value from another worksheet. It's even worse if you need to reference a value in a completely different Excel workbook!

As well as the standard, straightforward lookups, I can also handle Excel's powerful 'partial match' lookups. These allow you to insert wildcard characters like "?" and "*" to target specific data.

To save you a lot of time and hassle I can take your Excel files, set up your lookups, then return the package to you in full working order.

I'll even explain how to copy and adjust the formulas yourself, so that you'll be able to tackle a similar job in the future.

That's pretty good value for a very small investment!

What the Freelancer needs to start the work

Just send me the workbook(s) that you need to connect, and brief details of what you'd like to look up.

I'll set it all up, then get the working application back to you just as quickly as I can.

Please note that I'm working on the Windows platform only right now.

Reviews (2)

  • 02 Mar 2017 Matthew M.
    Matthew M.
    York, United Kingdom

    Fantastic as always, an Excel PRO!!!!

  • 05 Oct 2016 Matthew M.
    Matthew M.
    York, United Kingdom

    Truly excellent service!!!!

    Steve M.
    Steve M.

    Thanks Matt - really appreciate your positive review!

1080388950755
$15
Delivery in
1 day
Rating
100%
(2 reviews)

  • Views 165
  • Sales 1
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
Steve M.
Steve M.
Professional writer for SEO focused content, meta tags & blog posts

Hi, I'm a freelance writer specialising in blog posts on mindfulness, mental health and environmental issues. I'm also an Excel expert with experience in VBA customisation...Read moreHi, I'm a freelance writer specialising in blog posts on mindfulness, mental health and environmental issues. I'm also an Excel expert with experience in VBA customisation and advanced inventory management. I deliver a fast turnaround, with superb quality and a 100% focus on client satisfaction. I’m available online, seven days each week, with a guaranteed response to your order or questions within a few hours.

In the past, I've worked on-site as a part-time Systems Analyst for a UK based online retailer. I helped to manage a 70k product inventory. We used the Linnworks inventory/order management system to handle sales on multiple channels, including EKMPowershop, BigCommerce, Amazon, and eBay. We also used a highly automated CRM system to manage customer services queries.

Along with People Per Hour, I also use Twitter, TweetDeck and Crowdfire to market my freelancing services. I also do a little graphic design for logos, flyers and image processing.

I've now returned to freelancing full-time. Google 'freelancesteve' for the details! Here on PPH I mostly work on blog post copywriting, technical product descriptions and meta descriptions for CTR. Currently, I'm one of the best-performing People Per Hour freelancers for meta description copywriting! I also have in-depth knowledge of organic, content-driven SEO which I gained as a volunteer on the Google Webmaster help forum.

I'm professionally qualified, having a BSc Honours degree in Information Technology which was awarded in 2006. The degree covered object-oriented programming, cyber-security, and artificial intelligence. My specialist area was relational database design.

Now I work regularly with clients from a wide range of countries, including the UK, Germany, Canada, India, and Taiwan. Even though I'm based in the UK, I routinely adapt my copy to either UK or US English.

United Kingdom
Contact

Money protection guarantee
Money Protection Guarantee
Project done or your money back


Consider also


  • Help you with your MS Excel problem, formula(s), or task
    Help you with your MS Excel problem, f... $25
    Ali S.
  • Provide vlookup formula to ease task in excel.
    Provide vlookup formula to ease task i... $15
    Savita R.
  • Create modify or fix formulas in Excel
    Create modify or fix formulas in Excel $15
    Muhammad Barkat H.

Product

  • About
  • Team
  • Careers
  • Blog

Support

  • How it works
  • Trust & Safety
  • Help Centre

Discover

  • PeoplePerHour Plus
  • Academy

Resources

  • Customer Stories
  • Business Cost Calculator
  • Startup Cities

Browse

  • Freelance Services
  • Freelance Services By Country
  • Freelance Skills
  • Terms
  • Privacy
  • © 2021 People Per Hour Ltd
We use cookies to improve your experience and our services. By using PeoplePerHour, you agree to ourCookie Policy