Vlookup with Reference cell from Sharpoint
 

Hi,

I have a cell (Ex : Emp ID) in a XL sheet, whenever i enter an ID, it should
go to Web Sharepoint folder and refer the Emp ID with the Global XL Sheet and
returns the value (ex : Employee's Name)

How is it possible ?