Data manipulation between 2 workbooks

[ryalmokas]

I have a "master" worksheet with 11 columns of data, including a column of symbols in col. A (up to 100 symbols).

I have another workbook, whose col. A contains my "master" symbols and many more (up to 500 symbols).

I want to use the symbols from "master" 1 at a time, find the matching symbol in the bigger workbook, take the value in col. J for the matching symbol, and put that value col. K of "master".

Also, in doing this, do both workbooks have to be open, or can the bigger one be closed?

Thanks for any help with the above.

 

[Jonmo1]

=INDEX('C:\Documents and Settings\****\Desktop\Inv_Intell.xls\[Sheet1]Sheet1'!$J:$J,MATCH(#REF!,'C:\Documents and Settings\****\Desktop\My_Turtle.xls\[Sheet1]Sheet1'!$A:$A,0))

ok, BOTH Paths and Filenames should be EXACTLY The same, they both refer to the "big" file...

Try like this

=INDEX('C:\Documents and Settings\****\Desktop\[Inv_Intell.xls]Sheet1'!$J:$J,MATCH(A2,'C:\Documents and Settings\****\Desktop\[Inv_Intell.xls]Sheet1'!$A:$A,0))

Inv_Intell.xls is the "big" FILENAME
Sheet1 is the SHEETNAME in the "big" file
A2 is the value from "little" that you want to find in "big"

 

[ryalmokas]

jonmo1:

Thanks for your patience and help.
What you last posted works like a champ.

Best regards.