Index, Match with AND formula

Wendel Harder

I am trying to create a index, match formula were I need to match 2 criteria's. is this possible? I tried the following with AND . This returns "INVALID DATA TYPE"

=INDEX([Column4]68:[Column4]72, MATCH(AND([Column2]68:[Column2]72, [Column8]68, [Column3]68:[Column3]72, [Column7]68), 0))

Paul Newcome

Are you able to provide some screenshots or more detail as to your process? I may have a few ideas, but I want to make sure we get you the correct solution.