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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple variable lookup tables
use the index function, this function will allow you to select the lookup cells/value's and the column/row it must look for a match. It will return the value of the intersecting cell.cgrin Cheers -- willemeulen ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93678 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple variable lookup tables
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple variable lookup tables
I have a slightly different query now.
This is a sample of my table FTSE LEUR LESF BRH Futures 0.03 0.03 0.03 CTSL 0.04 0.04 0.04 GH Kapital 0.06 0.06 0.06 Northern Spark Trading 0.04 0.04 0.04 James Sullivan Group 0.05 0.05 0.05 TDT 0.04 0.04 0.04 Triniti 0.03 0.03 0.03 Paragon 0.03 0.03 0.03 If I wanted to look at FTSE for BRH Futures is it best to do a list: CTSL FTSE 0.04 TDT LEUR 0.04 etc If the top way is easier - how would I do the formula? Thanks for all your help so far. |
Reply |
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) |