Hi
have a look at VLOOKUP. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

"Donna" schrieb im Newsbeitrag
...
I use Ecel 2002. I have two spreadsheets that I use to tie down
payments.
One spreadsheet has the order and one has the payment. Each has the
order
number. Can you tell me how to combine the data to show which orders
I have
received payment on and which orders I have not received payment on?