Forum Discussion

Copper Contributor

Oct 18, 2018

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...

excel

Lorenzo Kim

Bronze Contributor

Oct 18, 2018

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..

Gabriel Díaz Muñoz

Copper Contributor

Oct 18, 2018

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!!

example.xlsx16 KB

Lorenzo Kim
Bronze Contributor
Oct 19, 2018
there are many good people here at the forum that may offer you solution to your query... good luck
- Lorenzo Kim
  Bronze Contributor
  Oct 19, 2018
  pls see attached file.
  thanks..
  gabriel.xlsx31 KB