Help about dynamic value table array in Vlookup

[mancubus]

Hi I found the solved in VBA getting single like your post, but if i have not permission to access file path, can I get value of that?

it seems i did not refresh the page at time of posting my message, so i see this post now.

the code in post # 6 will pull a single value, if your table contains a unique item to be found.

if you can upload both of your workbooks (obfuscate the confidential info, if any) i can provide a tailored solution.