Hi , Im trying to get the following formula , not sure if im trying too hard...
I want to First Search for Category 1 , 2 or 3 THEN - search for A, B, C Or D (Within that CATEGORY) , and then OUTPUT THE PRODUCT,
This is what im using but its not working:
Any help i s appreciated.
I want to First Search for Category 1 , 2 or 3 THEN - search for A, B, C Or D (Within that CATEGORY) , and then OUTPUT THE PRODUCT,
This is what im using but its not working:
Excel Formula:
=INDEX(A2:A4,,MATCH(H8,INDEX(B2:G4,MATCH(H7,B1:G1,0),),0))
Any help i s appreciated.