checking return receipt

[AJ]

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.