Re: VLOOKUP Exchange Rate from 12 different Workbooks Depending Upon Month Column
Not ideal. a couple of options (NOT great options, but options)
1) a REALLY REALLY HORRIBLE choose function or bunch of if functions. This should theoretically work, but just thinking about it makes me throw up a little
2) 12 hidden columns - each hidden column pulls in the exchange rate for 1 month, and then you can use a formulae to pick the value in the appropriate column to display in the visible column
3) VBA - a UDF could accomplish this without too much difficultly, are macros "allowable" at your company?
Really the best solution is (as Windy58 said) to consolidate the workbooks.
If any of the above 3 sound appropriate, post back and I can give more help on the specific one