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.