![]() |
Linking worksheets
I have a customer list on one worksheet and a vehicle list on another
worksheet. On both worksheets I have a customer number that is common between both - I need to combine these worksheets matching the information based on the customer number - help please. |
Linking worksheets
You didn't supply details of the columns you use, so I can't suggest
an actual working formula. However, check out the function VLOOKUP in XL Help - it will do exactly what you want. If you need any further help then post back with further details of how your data is arranged. Hope this helps. Pete On Feb 18, 6:22*pm, Iannelli wrote: I have a customer list on one worksheet and a vehicle list on another worksheet. *On both worksheets I have a customer number that is common between both - I need to combine these worksheets matching the information based on the customer number - help please. |
All times are GMT +1. The time now is 05:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com