I have a small table with formatted currency conversions that is fetched from a datasource online.
I would like to create a custom function that I can use in worksheets to convert a value from one currency to another. I
figured the function would look something like this:
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
Value = Value to be converted
Curr_in = Currency the value is in (i.e USD)
Curr_out = Currency to convert value to (i.e SEK)
I was thinking that the function would work in 2 steps:
1. Look up curr_in and match it with the "Y-axis" in the table and the curr_out would match the X-axis to get the correct
2. multiply the value with found rate.
The table looks like this:
Could someone help me with this, or
point me in the right direction? I don't know where to start...