Help with a Lookup Formula
Use MATCH( ) with the value in G1 to find the relative position in the
column containing USD, EUR, GBP, then use INDEX around that with your
F12 value to tell you how far over to go to get the value you need.
Examples can be found in Excel's Help.
Hope this helps.
Pete
|