In article
,
Louja wrote:

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?

Does this help?

http://www.xl-central.com/lookup-multiple-criteria.html

--
Domenic
http://www.xl-central.com