I have the need to 'pull' some information from a separate workbook. Lets say i have two workbooks, one named 'A' and the other 'B'. Workbook 'A' needs to search a given Sheet and Range on Workbook 'B', then upon finding the 'Target' value, pull the address of the cell.
I've tried two methods, Find(Target) & Application.Vlookup, Find(Target) fails to find the searched for value while Application.Vlookup finds the searched for value but i cant determine the cell address.
I of the two methods i would prefer to get the Find(Target) working but any help with either would be appreciated.

For Each rCell In ThisWorkbook.Worksheets("" & PrizeCostWk & "").Range("D" & Start & ":D" & Finish)
Target = rCell.Value
Set wb = Workbooks.Open("" & File & "", True, True)

'Vlookup Method works but cant FoundIt.address
FoundIt = Application.VLookup(Target, Sheets("" & ArcadeName & "").Range("C7:C1370"), 1, False)

'Find(Target) Method fails to find Target value
Set r = wb.Worksheets("" & ArcadeName & "").Range("C7:C1370").Find(Target)
If Not r Is Nothing Then TargetAddress = r.Address
Any ideas i'm stumped