Check cells content based on a table
 

I have 2 spread sheets. 1 sheet has codes in each cell, Like "BV09n" (there
are about 40 different codes) and they change daily. The other sheet has all
the codes that need to be in the first sheet each day. What formula would I
use to check the first sheet (using the 2nd sheet) for missed or duplicate
codes which are manually changed and screwed up regularly?

Thanks
Dave
--
David L

Check cells content based on a table
 

what do you mean exactly by "in every cell"

let's say your codes are in column a row 1:40.
you could put following formula in column b row 1:
=IF(ISERROR(VLOOKUP(A1,Sheet2!A:A,1,FALSE)),"ERROR ","Correct")

this expects the correct codes to be in Sheet2!A:A.
Change this to your needs.

then you can copy down this formula.

hth

Carlo

On Nov 22, 9:45 am, David L wrote:
I have 2 spread sheets. 1 sheet has codes in each cell, Like "BV09n" (there
are about 40 different codes) and they change daily. The other sheet has all
the codes that need to be in the first sheet each day. What formula would I
use to check the first sheet (using the 2nd sheet) for missed or duplicate
codes which are manually changed and screwed up regularly?

Thanks
Dave
--
David L