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

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