Added Rows not appear in linked worksheets

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:
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.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,203,460
Messages
6,055,556
Members
444,797
Latest member
18ecooley

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top