-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Things I’ve Learned About The Good Old U S of A From Watching Films And Telly
- Thread starter xlHammer
- Start date
Excel Facts
VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
I might be wrong but I would want to buy Dollars when they are as high as possible so I get more for my money.
For instance a souvenier in the US costs me $100.
6 Months ago the exchange rate was about 2 so it would have cost me £50
Now its 1.83 the same souvenier will cost me £54.64
Now assuming I wanted to take $2000 spending money - thats almost £100 more expensive.
The benefit for the UK are people that export to the US.
If I sell my product in the UK for £100 in march I would have sold it for $200 now I can sell it for $183.00 and make the same money.
For instance a souvenier in the US costs me $100.
6 Months ago the exchange rate was about 2 so it would have cost me £50
Now its 1.83 the same souvenier will cost me £54.64
Now assuming I wanted to take $2000 spending money - thats almost £100 more expensive.
The benefit for the UK are people that export to the US.
If I sell my product in the UK for £100 in march I would have sold it for $200 now I can sell it for $183.00 and make the same money.
cornflakegirl
Well-known Member
- Joined
- Nov 4, 2004
- Messages
- 2,023
Thanks for the windows explanation Greg. And for the handles one too - still don't understand, but now I know where to go looking if I ever need to work with mainframes!
Everything that I know about US politics, I learnt from The West Wing. Sometimes I forget that Jed Bartlet isn't actually the President...
Everything that I know about US politics, I learnt from The West Wing. Sometimes I forget that Jed Bartlet isn't actually the President...
Hi kgkev
Its the terminology that is back to front, that's all. Your theory is correct. However, when you can buy more dollars for your pound, it's the dollar that is weak(er), hence low. So, to get more dollars, you want the dollar to be low against the pound, or the pound to be high against the dollar. Same difference.
Its the terminology that is back to front, that's all. Your theory is correct. However, when you can buy more dollars for your pound, it's the dollar that is weak(er), hence low. So, to get more dollars, you want the dollar to be low against the pound, or the pound to be high against the dollar. Same difference.
Actually, I think Ms Palin will be the first woman president of the USA before Mr Obama will take that office. All it would take is for Mr McCain to cash in his chips.
