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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to format cells on several worksheets 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Excel If a Cell Contains a Certain Text (From Another Table) 0
Change all text on Spread sheet 1
Change cell background color based on content that results from li 4
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Excel A CountIF question... I think 2
Summary Worksheet. 1

Back
Top