Hello,

Basically I'd like the below index/match formula to work regardless of who's desktop it is.
=INDEX('C:\Users\userx\Desktop\[datafile.xlsx]sheetx'!R$1:R$65536,MATCH(A3,'C:\Users\user\Desktop\[datafile.xlsx]sheetx'!A$1:A$65536,0))


I've found a function to locate the desktop, below, but I'm not sure how to use it in the formula.


Function GetDesktop() As String
Dim oWSHShell As Object

Set oWSHShell = CreateObject("WScript.Shell")
GetDesktop = oWSHShell.SpecialFolders("Desktop")
Set oWSHShell = Nothing
End Function

Thank You