If Function for merging multiple worksheets
 

I have several worksheets I need to merge which contain some of the same
information in all of them (ex: Customer Account Number, Customer Name). In
lieu of adding the different information from different worksheets for one
account, is there a formula I could use to combine one account's information
to online, using multiple columns for the all the different data?

Thanks for your help!

If Function for merging multiple worksheets
 

Pick the sheet with the most data on it, and use VLOOKUP formulas to pull the
information from the other sheet to add to the first.

On sheet2, assume the Account # is the most specific searchable data, put
that column on the far right.

Then on the sheet you're pulling TO, find the first empty column, perhaps D,
and use a formula like this to grab data from Sheet2:

=VLOOKUP(A2,Sheet2!$A$2:$M$1000,2,FALSE)

This will look at the accout number in cell A2, find it in A column on
sheet2, then bring over the data from the SECOND column. To get the third
column, change that ,2, to ,3, ...etc.

Copy that formula down.

Will that get you started?

--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Brandy" wrote:

I have several worksheets I need to merge which contain some of the same
information in all of them (ex: Customer Account Number, Customer Name). In
lieu of adding the different information from different worksheets for one
account, is there a formula I could use to combine one account's information
to online, using multiple columns for the all the different data?

Thanks for your help!

If Function for merging multiple worksheets
 

CORRECTION - I meant put the Account # column on the far LEFT. VLOOKUP
requires the searched column to be on the left.
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"JBeaucaire" wrote:

On sheet2, assume the Account # is the most specific searchable data, put
that column on the far right.