MATCH() returns the row that the match was found in. VLOOKUP() returns
the corresponding value in a specified column. From your description it
sounds like you want VLOOKUP.

Jerry

Manos wrote:

Dear all

I am working with excel xp edition
i have a workbook which involve 9 sheets with the same format.
in column B of each sheet there is a 6 digit code (620035) and in the column
c, d, e there are some values.
I am working in another sheet which i have the same format with the others.
In column b i have all the codes from the other sheets.
There is any possibility to use match or vlookup function in order to say
if the code form sheet 10 is equal with code in sheets 1,2,3,4,5,6,7,8,9
then add the appropriate values in column c, form respective columns C?

Thanks in advance
Manos