L
Louja
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?
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?