How to bypass the #N/A error for indirect array formula.

[RabiMSingh]

Hi All,

This is my first post. I have this array formula
{=INDIRECT(Category)}
I am trying to fetch the list of data from two different tables into B5:B25 as the number of data may increase in time.

Here Category is a name of a table.
In this Table there are two Categories, 1. Student 2. Teacher. This list has been pulled using the data validation list.
There are two more table with the names Student and Teacher. What i am trying to do is to fetch the data from those tables (Student and Teacher) as per the selection in Category table. The numbers of data in both table are different. Hence this #N/A is showing in Cells where there is no data in corresponding table.

Regards,
Rabi M. Singh

 

[RabiMSingh]

Hi All,

Request a solution for above problem. I would highly appreciate your help.

Regards,
Rabi M Singh