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 :-)

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: 1482) 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.

Discuss

Answer the Question

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