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.