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 ...
Remove Vlookup #N/A Error in Excel
Tutorial: How to remove the #N/A error from Vlookup and replace it with a friendly message or a bl...



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.