hi,

I am interested in the case wheter is it possible to lookup or vlookup in the web hosted Excel workbook?

In my case I have file which includes some criteria, but the file where I have to lookup is hosted on the web and is updated daily, I want to lookup according the current date, the value in that hosted file.

Can I lookup in external workbook on the web? or is there any other way to import data from this hosted external excel file, so that it will be updated daily according to that file.


Regards...