|
Re: Is there an Excel formula
Posted 4/26/2007 11:42:32 AM by Waste06 Try this: You need 3 columns Column A has all the invoices numbers Column B is the 2nd list of invoices numbers If you want to see if Column B is missing any invoices that are in column A, then: In Column C type: =VLOOKUP($A1,$B$1:$B$8,TRUE,FALSE) You can copy this formula for all of column C. If there is a number in in Col.A that is not in Col.B, then you should get a #N/A. This assumes your list is only 8 rows and starts in row 1 and ends in row 8 (for example purposes). These numbers would change depending on the size of your list. HTH!!! I tried it with a few sample numbers and it worked for me. |