INDEX MATCH returning #N/A for absent values

[naveeddil]

Dear all,

I'm Having One Table of base data and other table have data coming from field.
I fetch data into second table via

=INDEX(TABLES!$B:$B,MATCH([@UC],TABLES!$A:$A,))

Out of 25 Districts im having data for 3 districts only in the basetable for rest of the 23 districts it is returning #N/A error.


For single district i tried IF condition as below and it worked but i m havign data of 3 districts so how to include three districts in it.
[TABLE="width: 120"]
<colgroup><col></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
=IF([@District]="Peshawar",INDEX(TABLES!C:C,MATCH([@UC],TABLES!$A:$A,)),"")


Can you please suggest any alternate formula or how to avoid the #N/A error.

 

[Aladin Akyurek]

One of:

=IFERROR(INDEX(TABLES!$B:$B,MATCH([@UC],TABLES!$A:$A,0)),"")

=IFNA(INDEX(TABLES!$B:$B,MATCH([@UC],TABLES!$A:$A,0)),"")

 

[naveeddil]

Dear Aladin,

Thanks for the updated formula
Worked like a charm

 

[Aladin Akyurek]

Dear Aladin,

Thanks for the updated formula
Worked like a charm

You are welcome.