How do I merge data from one worksheet with data from another wor.
 

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?

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?