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 ...
How to use Vlookup Across Multiple Worksheets in Excel
Tutorial: This tutorial shows you how to use the Vlookup function across multiple worksheets within ...



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.