View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deeds Deeds is offline
external usenet poster
 
Posts: 113
Default Index Match 2 columns 1 row

I am sure this is out there somewhere...I just can't find it.

A B C D E
Cage Box Kennel
Dog 2008 5 6 7
Cat 2008 4 3 2
Fish 2008 8 9 1

I need to find the number 3:
Cat, 2008, Box=3

How do I get it with Index & Match?
Thanks in advance