Consolidate sheets

[Guest]

Dear All

I am working with XP edition and i want to consolidate two sheets to a
third one.

Both sheets have a first column with code, a second column with a sort code,
a third column with a description and another 12 columns, one for each month.
i want to create a third sheet which will bring all the data from the other
two sheets.
There is any posibility to use a formula, for sort code (column b) in order
to pull all the data to one sheet and at the same time for each sort code to
have all aditional information?

I can bring all the data by using vlookup. But how can i bring all the sort
codes to the third sheet ?

Any good ideas?

Thanks in advance

 

[Bob Phillips]

Would you not just use lookup for that too?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Manos]

I am not sure

I want a function to bring me all the valus from both sheets sortly asceding
and do not have the duplicates Imagine to areas to be matched and bring them
as one.

I am not sure how to use match function and the appropriate ranges