software

Hello,
I am trying to find the best way to look up data using 5 different
criteria, and I would like it to find an exact match or the next
highest match in column A what would be the best way to do this??
andyI asked for exact match, first occurance and last occurance last wek (in a
different group)
This response works to get an exact match:
I'm not sure if it would actually speed things up for you but you could
find the first match for 2 conditions something like this

=MATCH(1,INDEX((A1:A1000=quot;applequot;)*(B1:B1000=quot;banan aquot;),0),0)
and the last with
=MATCH(2,INDEX(1/((A1:A1000=quot;applequot;)*(B1:B1000=quot;bananaquot;)),0))
you can add more conditions quite easily
daddylonglegs

I'm not sure about quot;next highest matchquot; but you might try changing the quot;,0quot;
switch in the match function
Good luckquot;dmexcelquot; gt; wrote in message oups.com...
gt; Hello,
gt; I am trying to find the best way to look up data using 5 different
gt; criteria, and I would like it to find an exact match or the next
gt; highest match in column A what would be the best way to do this??
gt; andy
gt;