Excel Forum
Similar Content
Basic Web Query in Excel - Import Data from the Web into Excel
Macro: Import data from the web into Excel with this macro. This is a basic web query macro that ...
Display The Actual Link / Email Address From Links in Excel - UDF
Macro: Display the actual link or email address from links within Excel with this UDF. This user ...
Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface
Tutorial: Learn to make a beautiful and intuitive date filtering interface for your data in Excel t...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick #94: VLOOKUP Into Web Query


See how to use a currency web query, and then link it to a data validation cell drop down list and a VLOOKUP formula that transforms a Balance Sheet from One Currency To Another.

VLOOKUP and Web Query and Data Validation

Formula and functions





Got a Question? Ask it Here in the Forum.