VLOOKUP asking for path update, where is the error?

[CaptainCsaba]

Range("F26").Select       
 ActiveCell.FormulaR1C1 = _
        "=VLOOKUP(RC[-1],'F:\infestor profiles\UK Holdings BP\[Things things things.xlsx]Sheet1'!C3:C5,2,FALSE)"
Range("G26").Select
 ActiveCell.FormulaR1C1 = _
        "=VLOOKUP(RC[-2],F:\infestor profiles\UK Holdings BP\[Things things things.xlsx]Sheet1'!C3:C5,3,FALSE)"
Range("F26").Select
Selection.AutoFill Range(ActiveCell, ActiveCell.Offset(0, -1).End(xlDown).Offset(0, 1))
Range("G26").Select
Selection.AutoFill Range(ActiveCell, ActiveCell.Offset(0, -1).End(xlDown).Offset(0, 1))

I have the following code. Whenever I run it it asks 6 separate times for me to find the "Things things things" workbook. For some reason it does not seem to find and I can'T figure out where the problem is, since this is the path. It might be because it is on a separate server but still the path should be fine. Where is the problem?

 

[Lavina]

Re: VLOOKUP asking for path update, wheer si the error?

Range("F26").Select       
 ActiveCell.FormulaR1C1 = _
        "=VLOOKUP(RC[-1],'F:\infestor profiles\UK Holdings BP\[Things things things.xlsx]Sheet1'!C3:C5,2,FALSE)"
Range("G26").Select
 ActiveCell.FormulaR1C1 = _
        "=VLOOKUP(RC[-2],F:\infestor profiles\UK Holdings BP\[Things things things.xlsx]Sheet1'!C3:C5,3,FALSE)"
Range("F26").Select
Selection.AutoFill Range(ActiveCell, ActiveCell.Offset(0, -1).End(xlDown).Offset(0, 1))
Range("G26").Select
Selection.AutoFill Range(ActiveCell, ActiveCell.Offset(0, -1).End(xlDown).Offset(0, 1))

I have the following code. Whenever I run it it asks 6 separate times for me to find the "Things things things" workbook. For some reason it does not seem to find and I can'T figure out where the problem is, since this is the path. It might be because it is on a separate server but still the path should be fine. Where is the problem?

Hey,

why are you giving a full path but not opening the file?
Since I'm assuming you plan to have the file open at the time then your vlookup should be:
=VLOOKUP(RC[-2],[Things things things.xlsx]Sheet1'!C3:C5,3,FALSE)

If you do not have it open, you then need to open it with Workbooks.Open Filename:=”File_Name”, and then use the same vlookup

 

[Fluff]

Re: VLOOKUP asking for path update, wheer si the error?

The formula in G26 is missing the opening apostrophe '