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 coincidence of two cells of that same row, how can I do this?
for example: in sheet1, cell A2 and cell B2 must have the same info that sheet2, cell A2 and cell B2, to copy the data conteining in cell C2 of sheet1.
i hope i have been clear enought
thanks in advance.
4 Replies
kindly attach a non-sensitve sample for people here to have a better view of your query.
write down on sheet what you want to achieve.
thanks..
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
