I have a spreedsheet with a long list of things that must be tracked and
updated daily.

Each day we get new things and we have to determine if they are already in
the sheet. If so, no update is necessary, in not, then we have to add the
information.

What I wanted to do was create a smaller range in the sheet and add the
10-20 new things we get each day to that range. Then VLOOKUP would go down
the big long list and tell us which are not in the list. That would save us
a great deal of time. I'm not sure I can do this though.

I had partial success by defining a set range of 10 cells and placing the
VLOOKUP in each cell. Then in the cell across from it, I entered the new
number. If a "N/A" appears, then it isn't in the long list and we know to
enter the number.

This doesn't seem right...is there a better way to do this?

Thanks!!