INDEX MATCH not displaying results

[stefanp]

My workbook with multiple INDEX/METCH array functions has stoped displaying results. The formulas look like:
{=IFERROR(INDEX(Cou,MATCH(1,(Nat=$C81)*(shop=$D$2),0),1),"")}
I also tried with:
{=IFERROR(INDEX(Cou,MATCH($C81,Nat,0),MATCH($D$2,shop,0)),"")}
where Cou, Nat and shop are names of data ranges

Anyone can help?

 

[galt13]

If either Nat=$C81 or shop=$D$2 is untrue the match function generates and error. When that happens you have the code set up to output "". I'd use formula audit on one of the cells that I was expecting output in and see which one is false.

 

[Aladin Akyurek]

My workbook with multiple INDEX/METCH array functions has stoped displaying results. The formulas look like:
{=IFERROR(INDEX(Cou,MATCH(1,(Nat=$C81)*(shop=$D$2),0),1),"")}
I also tried with:
{=IFERROR(INDEX(Cou,MATCH($C81,Nat,0),MATCH($D$2,shop,0)),"")}
where Cou, Nat and shop are names of data ranges

Anyone can help?

These formulas implicate different layouts, so they can't be compared without knowing the layout.

What does the following return?

{=INDEX(Cou,MATCH(1,(Nat=$C81)*(shop=$D$2),0),1)}</SPAN>

 

[galt13]

Uhhhh looking closer I don't see any way for that code to generate any output. Maybe I'm missing something though. Looks like if there is an error it generates null otherwise it generates nothing

 

[stefanp]

Thanks guys
I've since solved the mystery. It was the formatting of the cells that i somehow changed. It works now wit the original function:
{=INDEX(Cou,MATCH(1,(Nat=$C81)*(shop=$D$2),0),1)}
It returns a lookup by 2 parameters