New to the forum and hoping to get some help. I have a spread sheet that needs to pick up a txt value in one column(exchange rate) ie USD, EUR, AUS, CDN and then multiply a value in an adjacent column based on the exchange rate chosen; just wondering how I might accomplish this?
Thanks
You might use some sort of lookup function. If you provide a little more information, preferably a sample workbook, you'll probably receive more specific advice...
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
Here is a snapshot of the columns i'm trying to work with to perform the function.
20-08-2012 2-25-01 PM (2).jpg
Do you have a catalogue with exchange rates? Where in the workbook are they placed?
I can, they can be located in the tab I have for my drop down lists
Then assuming $88,000 is placed in K3, then in J3 put:
Formula:
Please Login or Register to view this content.
And copy down.
Thanks for the help but for some reason as I copy the formula down it is increasing the value of the array by the same rate its increasing the value for the column I,
This is the first row which works fine
=INDEX(T4:T7,MATCH(I3,R4:R7,0))
This is the second row where it adds 1
=INDEX(T5:T8,MATCH(I4,R5:R8,0))
You'll need to use $'s. They stop your arrays from changing as you copy down; like so:
Formula:Please Login or Register to view this content.
Last edited by Søren Larsen; 08-20-2012 at 03:27 PM.
Thanks, works perfect!
Great! don't forget to mark your thread as solved...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks