Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up a reference which has more than 1 exact match
I need to use some kind of a Lookup that will grab 2 references for the
Lookup conditions. Look up a reference which has more than 1 exact match, so then i need to look for a second condition which sets these apart. I am using a Lookup command to get a value from a SQL table but the following formula formats as text which the Lookup will not allow for a range of cells. So I thought I could use Match in two different conditions and reuse the results in the Lookup, but it results in text which the Lookup will not use for a range. is there a way to convert this answer to a format that Lookup will accept? ="B" &MATCH(0.927, Table_cppistons01_eng1_luHorzEndLockDia[[#All],[PinBoreSize]],0)&":"&"B" &MATCH(0.927,Table_cppistons01_eng1_luHorzEndLockD ia[[#All],[PinBoreSize]],1) Ultimately this is what i need to end up with. =LOOKUP(5,B97:B104,D97:D104) Or if there is a way to Lookup more than 1 reference and return a value. -- Regards, KJ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look up a reference which has more than 1 exact match
Try these Custom Functions
http://www.ozgrid.com/VBA/occurrence-lookup.htm http://www.ozgrid.com/VBA/2-criteria-vlookup.htm http://www.ozgrid.com/VBA/3-criteria-vlookup.htm http://www.ozgrid.com/VBA/4-criteria-vlookup.htm http://www.ozgrid.com/VBA/5-criteria-vlookup.htm -- Regards Dave Hawley www.ozgrid.com "KJ" wrote in message ... I need to use some kind of a Lookup that will grab 2 references for the Lookup conditions. Look up a reference which has more than 1 exact match, so then i need to look for a second condition which sets these apart. I am using a Lookup command to get a value from a SQL table but the following formula formats as text which the Lookup will not allow for a range of cells. So I thought I could use Match in two different conditions and reuse the results in the Lookup, but it results in text which the Lookup will not use for a range. is there a way to convert this answer to a format that Lookup will accept? ="B" &MATCH(0.927, Table_cppistons01_eng1_luHorzEndLockDia[[#All],[PinBoreSize]],0)&":"&"B" &MATCH(0.927,Table_cppistons01_eng1_luHorzEndLockD ia[[#All],[PinBoreSize]],1) Ultimately this is what i need to end up with. =LOOKUP(5,B97:B104,D97:D104) Or if there is a way to Lookup more than 1 reference and return a value. -- Regards, KJ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup & exact match | Excel Worksheet Functions | |||
Find an exact match and go to that match | Excel Discussion (Misc queries) | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
Match name not exact | Excel Worksheet Functions | |||
Getting an exact match | Excel Worksheet Functions |