G
Guest
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
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