Look up a reference which has more than 1 exact match

  • Thread starter Thread starter KJ
  • Start date Start date
K

KJ

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_luHorzEndLockDia[[#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.
 
Back
Top