Would you not just use lookup for that too?

--

HTH

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


"Manos" wrote in message
...
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