View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kyle Kyle is offline
external usenet poster
 
Posts: 1
Default Comparing two lists

I want to compare the values in one list with the values in another list to
verify that thiere is a match for every one. The purpose is to make sure
that for every purchase order entered in quickbooks, there is an invoice the
has been created. The name in the memo field on the purchase order should
match the name on the invoice and if the purchase order does not have a match
have a cell that flags that purchase order. Can anyone help me with this
task. Sometimes one invoice may have several purchased orders that match and
in that case is there a way to list the number of accurances?
--
Kyle