INDEX MATCH 2 Column Criteria

[Maverick0174]

Hello guys,
I struggle...... shouldn't give the formula in below me in D4 "A1" return ?

Please Login or Register  to view this content.

I tried also this

Please Login or Register  to view this content.

INDEXMATCH.JPG

Thanks already for your hints
Andi

[AliGW]

No, but this should:

=LOOKUP(2,1/(($A$11:$A$18=$A)*($B11:$cB$18=$B)),$C$11:$C$18)

[Maverick0174]

No, but this should:

=LOOKUP(2,1/(($A$11:$A$18=$A)*($B11:$cB$18=$B)),$C$11:$C$18)

With

Please Login or Register  to view this content.

it does give A1 back. Thank you already.
But it works only for the A1 combination......
Attachment 648566

[Maverick0174]

Found the mistake.....

Please Login or Register  to view this content.

Like this it works......Thanks a lot for the successful hint

[AliGW]

Oops - typo! Sorry about that - I have a sticky 4 key that sometimes doesn't work.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.