ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Linking worksheets (https://www.excelbanter.com/excel-worksheet-functions/256734-linking-worksheets.html)

Iannelli

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.


Pete_UK

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