revise formula to pull data from another spreadsheet

[Savuti]

Hello, the formula below works great, I need to however pull the data from one spreadsheet on drive A:\Target (name of folder) to the other spreadsheet on drive B:\Needed (name of folder). I am not sure where to enter the drive and folder information within the formula. I have tried but with strange results.

The bolded text ($A$2) is on the spreadsheet I am pulling the data to.

Thank you for your help.

=IF(ISNUMBER(MATCH([COLOR=red][B]$A$5[/B][/COLOR],$C$3:$M$3,0)),INDEX($C$6:$M$6,MATCH([COLOR=red][B]$A$5[/B][/COLOR],$C$3:$M$3,0)),"")

 

[texasalynn]

if you open the file and create the formula you want, save it. Then close the file you pointed to in the formula, it will show you how the formula needs to read. Note: excel drops off the path information when a file is open.