Hello, I am creating a spreadsheet that I will use to search species and their habitats from information downloaded from the World Wilflife Fund's Wildfinder website. I have already created a spreadsheet that can do a simple filter to search for 1) Common Names 2)Ecoregion Names and 3)Ecoregion Codes. I.e. if I search for "Tiger" with the Common Name Button selected it would bring up a list of all the Ecoregions in which tigers are found. I would like to further enhance this spreadsheet to be able to input multiple species and find their common ecoregions. I.e. if I enter into the 4 different search boxes "Tiger", "Red Panda", "Sloth Bear", and "Rhino" with the Common Name button selected it would bring up a list of all the Ecoregion Names (with cooresponding Ecoregion Code) in which these four species share.
The info. is in the following format:
Column A - Ecoregion Code, Column B - Ecoregion Name, Column C - Common Name, Column D - Class
What is the best way to organize my data to make what I want to do easiest?
Here is a portion of the original search file I created.
Terrestrial Ecoregions-Mammals.xlsm
Thanks,
-Drew
Bookmarks