INDEX MATCH across multiple sheet returning error

There are two sheets named MASTER1 and MASTER2. Code is entered in each sheet from B2 to B5000. Description of item is entered in each sheet from C2 to C5000.

There is an output sheet where an item is looked up in two master sheets based on the code entered. When a code in any of the sheet is entered, it gives correct description. I used the following formula

Please Login or Register  to view this content.

But, in the case of value of a code not present, “N/A” error occurs. I tried modifying the code as follows, but it is not accepting. Any help in spotting the error in the code will be appreciated

Please Login or Register  to view this content.

The formula works as desired. As a follow-up to this question, suppose if the master sheets are many in number, whether we have to include each INDEX- MATCH pair with this formula or is there any method to simplify the code.

Could you give a simplified syntax wherein sheet names start from A and run to G, and are with codes and description? The OUTPUT sheet has to display the output depending upon the code entered?

Note: In Sheet A to G, the code is in Col. A and description is in Col. B.