Performing a VLookup from the web

[niniodecoro]

Hi,

I have a problem.
I need to fill up an excel sheet which has more than 500 cells. manually filling up is a chore.
I have to fill up these values from a website for whom i have subscription (it is not free data).
Can I perform a Vlookup to do this action? Is there any other way I can do this other than Vlookup?
Any help would be greatly appreciated.

Thanks.

[zbor]

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. I will move it now but please in future choose appropriate forum, and post your question in ONLY one forum.

[Archibald_SM]

I too am interested to see if this can be completed for standard currency exchange rates.