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

Using VLookup for currency codes and exchange rates

0

Hi

I am trying to set up a Vlookup formula to select a currency code from a dropdown list on the income sheet (attached) (cell C2) and then return the corresponding exhange rate from the FX grid sheet.

My excel knowledge is fairly basic, so please be gentle :-)

excelvlookup
MS Office Version: 2010
posted by: Scotia on Tue Jul 11, 2017 at 6:52 am
Answer
Discuss

Discussion

Please don't forget to select the answer that worked best for you! Just click the Select Answer button at the bottom of the desired answer.
don (rep: 1989) Jul 13, '17 at 2:44 pm
Add to Discussion

Answers

1

Vlookup format  = vlookup(Lookup Value, Table/Array,ColumnIndex,ExactMatch?)

check out the attached.  I put in a cell to SHOW the conversion Factor (you could omitt, but it generally nice to see rate for verifying).  If you use the fx function in excel, it also shows you some hints and help with functions.  Type "=vlookup(" then hit the fx ~ it will help guide through many functions.

posted by: queue (rep: 467) on Tue Jul 11, 2017 at 9:37 am
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login