Find missing values

[ddsunil]

Hello Everyone
I am a normal user of excel and I am lost at how to do the following.

I have two sheets named Check and ChecksIssued. Checks issued has one column where all check numbers are mentioned. These are checks that were actually issued by my company. And the check is the list of check numbers that our accountant has entered into the system. Every month our accountant misses entering a few checks into the system which causes a discrepancy in the actual checks issued versus checks entered into our accounting system.

I want to know what check numbers our accountant missed. The reason I am explaining all this is, from reading on the net I thought VLookup may be what I need. But after reading my problem I am hoping that someone will let me know if vlookup should be used or something else to do what I am required to do. And if Vlookup is what I should use to get the solution, can you give me the formula so that I can directly use it in the cell since you know my sheet names?

Thanks so much
S

 

[Aladin Akyurek]

CheckIssued is sometimes incomplete compared to Check, right?

 

[Peter_SSs]

See if this helps.

Excel Workbook
	A
1	Checks
2	2
3	3
4	2
5	4
6	2
7	6
8
Check

Formula in B2 below is copied down.

Excel Workbook
	A	B
1	Checks Issued
2	1	Missing
3	2	Duplicated
4	3	OK
5	4	OK
6	5	Missing
7	6	OK
8
ChecksIssued

 

[ddsunil]

Aladin, sometimes that is possible.

Peter, you are a genius. Each time I learn something new in Excel I am surprised by the fact that there are so many things that One can do with Excel. Thanks again Peter. That works for me.

S