Forum Discussion
how can I combine the data of two different sheets?
I have one file conteining diferent sheets, and I want to combine the info of one of this sheets (2 columns of info) with the other one. to select the info in each row i have to verify the coinciden...
I hope with this example is clear enought to help me. :)
i'm using Excel 2013.
the information in the red circles are the ones that have to be the same (in both sheets), the ones in the black circles are the ones I want to colect from sheet2, and the ones in the green circle, would be the result of a succesfully formula.
the thing is that the information in column "no_req" and cve_prod could be repeted, but not at the same time, what I mean is, if you select only one number in column "no_req", no matter how many times it is repeated, all the cells in column "cve_prod" will be different, for that "no_req" number.
thanks in advance!!
there are many good people here at the forum that may offer you solution to your query... good luck