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??
andy

I 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="apple")*(B1:B1000="banan a"),0),0)
and the last with
=MATCH(2,INDEX(1/((A1:A1000="apple")*(B1:B1000="banana")),0))
you can add more conditions quite easily
daddylonglegs

I'm not sure about "next highest match" but you might try changing the ",0"
switch in the match function
Good luck


"dmexcel" wrote in message
oups.com...
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??
andy