Gingin8639
New Member
- Joined
- Jun 4, 2012
- Messages
- 3
I have a workbook that we use for running statistical analysis on vegetation surveys. In most of these sheets (in this case, the one I'm working with is called "EnterCoverData"), our first couple columns are linked to our master plants list (Campbell County). That way, instead of having to type out plant scientific names and risk the mispellings and such, we can just enter the identification code. This seemed to be working fine, but then I noticed we were missing some species from the list, so I added them. Now, when you enter the code, these new species don't appear. I know the formula in EnterCoverData works, because if I enter a code for a plant that was already in the list as compared to one of the new ones, it appears. Any suggestions as to why this might be happening and how to fix it?
The code I am using is:
I am using Excel 2010.
The code I am using is:
Code:
=IF(ISNA(VLOOKUP(A81,CampbellCounty,2,FALSE)),"",(VLOOKUP(A81,CampbellCounty,2,FALSE)))
Code:
=IF(ISNA(VLOOKUP(A81,CampbellCounty,3,FALSE)),"",(VLOOKUP(A81,CampbellCounty,3,FALSE)))
I am using Excel 2010.