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
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.
<colgroup><col></colgroup><tbody>
</tbody>=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.
I'm Having One Table of base data and other table have data coming from field.
I fetch data into second table via
Code:
=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.
<colgroup><col></colgroup><tbody>
</tbody>
Can you please suggest any alternate formula or how to avoid the #N/A error.