View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AJ AJ is offline
external usenet poster
 
Posts: 99
Default checking return receipt

I have on spreadsheet that is a list of orders that we have had to resend to
a customer for various reasons. Part of the info for each of these reshipped
order is a column for the original order number. I have another spreadsheet
that records recepts of returns from customers. This sheet has a separate
tab for each month.

I am wondering if there is a formula or function that i can put on the
reships spreadsheet that will check to see if an order has been returned by
looking at the returns spreadsheet.