Thanks to all of you. I needed away to make sure the memo field in my PO
list crossed referenced to an invoice. Hate to work so hard and forget to
invoice a customer.


"Kyle" wrote in message
...
I have two lists in a workbook, each on there own sheet. I want to find if
the value of on cell in list "A" has an exact match in list "B". Also how
can I strip all characters preceding the character "/" in a cell and also
remove the space that is right after the character "/"?