Index/Match formula across multiple sheets

Hi,
I need help in making a formula, using Index/Match to return a value that is looked up in multiple sheets. In my example I have a Main sheet and I have two data sheets (Inventory1 and Inventory2).
What I need is a formula in Main columns B and C, returning a value from either of the two Inventory sheets, ie:
Typing 123 in Cell A2 should then lookup, via Index/Match, in the two Inventory tabs and return the correct value: Name: 123 name; Price: 600.
It's probably simple but I only know the IFERROR and I can't use that as I am using IFERROR to return a blank cell if there are any errors in the lookup

I hope someone can help me.


Regards,
Brian

Not Index/Match, but it worked like a charm! Thanks

Hi again. The Vlookup Columns formula worked like a charm but now my formula has another problem. New sheets have been added.
So this formula, which covered 2 sheets, needs to be changed to cover 4 sheets: =IFERROR(IFERROR(VLOOKUP($A2,Sheet2!$A:$C,COLUMNS($A:B),FALSE),VLOOKUP($A2,Sheet3!$A:$C,COLUMNS($A:B),FALSE)),"")

I have attached a sample sheet. In Order info sheet I need cells in column B to return a value across the 4 Stock sheets (Stock A to Stock D).

Hope someone can help me with this.

Thanks. Worked like a charm