Prev: Can I pull Data from a list by store # and quantity
Next: duplicate values
From: Iannelli on 18 Feb 2010 13:22
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.

From: Pete_UK on 18 Feb 2010 14:10
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 <Ianne...(a)discussions.microsoft.com>
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.

 | 
Pages: 1
Prev: Can I pull Data from a list by store # and quantity
Next: duplicate values