Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
how do I make a copy of a worksheet and retain formulas but not data | Setting up and Configuration of Excel | |||
Extract Data for Mail Merge | Excel Discussion (Misc queries) | |||
Copy data into a NEW worksheet | Excel Discussion (Misc queries) | |||
Reference Data in Moved Worksheet | Setting up and Configuration of Excel |