View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default 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