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