The Excel Expert
  • Welcome to the Excel Expert
  • Blog
  • Books for sale
    • Your Excel Survival Kit
      • Get the e-book plus bonuses here!
      • Buy on Amazon.co.uk
      • Buy on Amazon.com
      • Create Great Reports in Excel
      • Create Great Reports in Word
    • Get and Transform your data
  • Products for Sale
  • Free Webinars
  • Testimonials
  • About
    • Resources
    • About
    • Privacy Policy
    • Terms of Use
  • Contact
Select Page

Using Vlookup for populating a scientific taxonomy list or channelling my inner Attenborough

by admin | Feb 10, 2014 | Excel Formulas | Essential Functions, Excel | General

I recently got asked to help with setting up a formula that would autofill standard entries for particular species. The idea would be that the user would enter a species name and then the other details would fill in as normal. While the example I’ve given here...

Excel shortcut keys – FREE

Recent Posts

  • My 21 for 2021
  • Cleaning up an accounts file with Power Query
  • Another way to “pivot” or “unpivot” – Excel style
  • Faster Filtering with Filter()
  • How to create a unique ID in Excel

Categories

  • Excel Formulas | Essential formulas
  • Excel Formulas | Essential Functions
  • Excel Functions | Useful
  • Excel Lists | List basics
  • Excel Lists | Sorting and Filtering
  • Excel Pivot tables | Introduction
  • Excel | Advanced Lessons
  • Excel | Case Studies
  • Excel | Conditional Formatting
  • Excel | Excel Beginner Lessons
  • Excel | Excel for Small business
  • Excel | General
  • Excel | Intermediate Lessons
  • Excel | Useful tricks
  • Personal
  • Powerpivot 2010
  • Training Records Management

Like Excel Expert on Facebook

Recent Posts

  • My 21 for 2021
  • Cleaning up an accounts file with Power Query
  • Another way to “pivot” or “unpivot” – Excel style
  • Faster Filtering with Filter()
  • How to create a unique ID in Excel

Like Excel Expert on Facebook

  • Resources
  • Welcome to the Excel Expert
  • About
  • Blog
  • Contact
® 2019. All Rights Reserved