Merging worksheets based on common cells in row

[VNS1000]

I have two worksheets I would like to merge. I need to merge the worksheets based on the cells being common in one particular column of each worksheet. Is there any functionality in excel to look at each the same colum in each of the worksheets and merge if it sees the same number, effectively giving me rows with combined data.

Thx

 

[AndreasG]

Hello

you can user vlookup function , or index-match combination

please give a more detailed example of what you need
so we can help you more



Best Regards
Andreas
using xl2002 on winxp

 

[VNS1000]

well I have two worksheets with a common column of numbers. The data in each worksheet is different. So for example . Spreadsheet 1: might be like this:

A B C
601500 10 20
601501 20 40

Spreadsheet 2 might be:

A B C D E
601500 20 40 50 60
601501 40 10 60 10

So I would like to merge the columns from both worksheets with the common cell being in column A.
Thanks

 

[AndreasG]

hello

In my humble opinion the best way to do it is with pivot tables working with multiple consolidation ranges

give it a try , in my example worked fine




Best Regards
Andreas
using xl2002 on winxp