multiple conditions

D

dmexcel

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
 
B

Bob Tarburton

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="banana"),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
 
Top