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

Published: Fri, 02/14/14

The Excel Expert

Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users

Using Vlookup for populating a scientific taxonomy list or channelling my inner Attenborough- 2014-02-10 06:55:10-05

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 is for scientific purposes, you could also adapt [...]
Read more...