Help pasting cells in certain order

[mleroy42]

Alright, I am working on a project and I know there has to be a quicker way to take information from one spreadsheet to another without typing 1,000+ values by hand.

Here is what I need to do:
In Document 1 (Doc1), I need to take the information in column C and paste it into column H of Document 2 (Doc2).
I need Columns A and C in Doc1 to be linked to one another when I copy because the values in Column A of Doc1 are present in Doc2 Column B. However, not every value in Column B, Doc2 is in Column A, Doc1.

Does anyone know how to do this? Or does this even make sense to anyone? I apologize for the confusing problem. I do not know how to explain it any easier than this. Thank you for your help!

 

[GlennUK]

So, if I understand this correctly, all you want is a simple lookup, in Doc2 col H, to retrieve values from Doc1 column C, looking up a match in col A of Doc1 for the values in col B of Doc1. It would be similar to this:

=IF(ISNA(MATCH(B2,Doc1!$A$2:$A$35,0)),"",INDEX(Doc1!$C$2:$C$35,MATCH(B2,Doc1!$A$2:$A$35,0)))

 

[mleroy42]

I think that is what I would need. Would I need to bring Doc1 and Doc2 into the same file just on different sheets? I can't figure out how to pull information from one document into the other. Thank you so much for your response!

 

[GlennUK]

You don't need to pull them into the same file ... to generate your formula have both the books open and navigate to the required ranges whilst editing your formula, and the references will generate automatically.