Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highting rows based on content of cells | Excel Worksheet Functions | |||
i have a check box that keeps clearing out my cells content | Excel Worksheet Functions | |||
Macro to highlight cells based on content | Excel Worksheet Functions | |||
Automatically filling in cells based on another cell's content | Excel Worksheet Functions | |||
Put an autoshape in a cell based on another cells content | Excel Worksheet Functions |