Ue of VLOOKUP for a Range of Items

R

Randy Brown

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!!
 
B

Bernard Liengme

Vlookup seems like overkill here
Le the 'long list be in A1:A1000
In C1: C10 enter the new values
In D1 enter =COUNTIF($A$1:$A$1000,C1)
Copy down to D10
Each formula will return 0 if item is not in list
Next day just replace the C1:C10 values
Formula could be =IF(COUNTIF($A$1:$A$1000,C1),"Present in list", "Item not
in list")
best wishes
 
Top