Check cells content based on a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top