View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Louja Louja is offline
external usenet poster
 
Posts: 17
Default Multiple variable lookup tables

I have to effectively do a lookup table on more than one variable
group and product code. I have a lookup table this is an extract.

Group Product code Long Name TTG fee currency
BRH Futures LEUR 3 MONTH EURO (EURIBOR) 0.03 GBP
BRH Futures LST 3 MONTH STERLING 0.03 GBP
BRH Futures CBO 30 YEAR TREASURY BOND 0.24 USD
BRH Futures CTN 5 YEAR TREASURY NOTES 0.24 USD
BRH Futures CBRP BRITISH POUNDS 0.22 USD
BRH Futures FCE CAC 40 FUTURE 0.17 EUR
BRH Futures CCD CANADIAN DOLLAR 0.22 USD
CTSL C CORN 0.24 USD
CTSL LCO CRUDE OIL BRENT BLND 0.08 USD

I wish to bring back the info in the TTG fee column - any ideas?