Thread: MATCH using multiple criteria?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
daddylonglegs[_6_] daddylonglegs[_6_] is offline
external usenet poster
  
Posts: 1
Default MATCH using multiple criteria?

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
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=507249

Reply With QuoteReply With Quote