T
Taru
Alright everyone, I know very very little about programing a function i
Excel.
Now that we have that out of the way this is what I'm looking at.
My boss gave me two excel sheets one is 626 rows and the other is 1300
rows and 256 columns. My job is to take a gene ID(listed in documen
1), search for it in document two, then once it is found it needs t
identify the cell in column A of what ever row it was found in an
paste it back in document 2.
Document 1's set up isn't important, but document 2 is setup as such:
Every cell in column A is the name that I need pasted, and in the res
of the cells in that row is where I will find the gene ID from documen
1. Let me write an example.
___A________B______C_______D_______
TC38123 CB61619 CD78923 DG909288
TC90123 CD99203 JR18239 JX920347
And document 2 continues on in this manner for a very long time.
So lets say I'm searching for CD78923 it will be found in C1, then
will look in column A of that same row to find the ID TC38123, then
paste that back in document 2. That is what I need a formula for an
so I ask you all for your help, because if I can't get a formula then
have to do it all by hand...:eek
Excel.
Now that we have that out of the way this is what I'm looking at.
My boss gave me two excel sheets one is 626 rows and the other is 1300
rows and 256 columns. My job is to take a gene ID(listed in documen
1), search for it in document two, then once it is found it needs t
identify the cell in column A of what ever row it was found in an
paste it back in document 2.
Document 1's set up isn't important, but document 2 is setup as such:
Every cell in column A is the name that I need pasted, and in the res
of the cells in that row is where I will find the gene ID from documen
1. Let me write an example.
___A________B______C_______D_______
TC38123 CB61619 CD78923 DG909288
TC90123 CD99203 JR18239 JX920347
And document 2 continues on in this manner for a very long time.
So lets say I'm searching for CD78923 it will be found in C1, then
will look in column A of that same row to find the ID TC38123, then
paste that back in document 2. That is what I need a formula for an
so I ask you all for your help, because if I can't get a formula then
have to do it all by hand...:eek