Matching Spreadsheet Data

[clundberg]

If I have two or three, etc spread sheets that I want to match data with and all spreadsheets have a customer ID # [so I would have a common demoninator for all spreadsheets] what would be the best formula to use to put all spreadsheet into one? Probably on the same line also. Example: I have a spreadsheet with customer name and address; and one with the customer billing address; one with customer billing monthly amounts. I want all customers informaiton on one spreadsheet on one line.

Thanks for your help

 

[JPM]

I would use Vlookups and bring all the info for one customer ID into the same line. Use Excel's vlookup help if you have questions, or post again.