Noob-Easy Stuff, Problem with syntax w/ VBA referencing another worksheet

[lougs7]

Hi guys! I don't know the proper syntax to do this

On my active workbook I am writting code, in the code I use the HLOOKUP function that looks up a value in another closed workbook, how would you do this, using variables assigned to the file it is searching would be preferred

current file: C:\Users\Suhail\Documents\work\Pro Fee Dash Board\Dash Board Shell.xlsm
retrieve data from file: C:\Users\Suhail\Documents\work\Pro Fee Dash Board\testdata.xls

for the HLOOKUP(lookup_value,table_array,col_index_num,[range_lookup})
I want lookupvalue to be my Current WorkBook>Sheet = "Data">Range A3
I want the Table array to be from the Retrieve data file>Sheet = "Sheet1">Range $A$2:$AK$1345
And I want it to paste the values the next column over from the look up value so I think = 2


I am not sure the quotations and syntax when referencing another workbook.worksheet inside a formula so I get errors....If anyone knows proper syntax to use please help

[6StringJazzer]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.