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.

Print Post      Close Window