Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Multiple Values from a variable table size | Excel Worksheet Functions | |||
Lookup tables with multiple columns | Excel Discussion (Misc queries) | |||
lookup and choose wih multiple tables of unequal column lengths | Excel Discussion (Misc queries) | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Using Multiple LOOKUP tables | Excel Discussion (Misc queries) |