Hi Guys,
I am using this formula to index product data from one sheet and it works fine.
I needed to another sheet. How do I add another sheet to this formula? The other sheet is called “InjectableProductData” and it has the same ranges. I tried this but it did not work.
Any ideas?
I am using this formula to index product data from one sheet and it works fine.
Code:
INDEX(OralSolidProductData!C1:Q38,MATCH(E15,OralSolidProductData!C1:C38,),MATCH(C17,OralSolidProductData!C1:Q1,))
I needed to another sheet. How do I add another sheet to this formula? The other sheet is called “InjectableProductData” and it has the same ranges. I tried this but it did not work.
Code:
IFERROR(INDEX(InjectableProductData!C1:T38,MATCH(E15,InjectableProductData!C1:C38,),MATCH(C17,InjectableProductData!C1:T1,)),IFERROR(INDEX(OralSolidProductData!C1:Q38,MATCH(E15,OralSolidProductData!C1:C38,),MATCH(C17,OralSolidProductData!C1:Q1,))))
Any ideas?