Excel Forum

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.