Linking worksheets

[Iannelli]

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]

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