I am looking to write a formula that retrieves cost based on color of jeans and size. The data is in 5 different tables and I do not want to reformat the data due to how it comes out of the system. I attempted to write a INDEX MATCH MATCH, but it does not work in the situation. I want the INDEX range to encompass all of the five tables so I can input different color and size combinations to receive the cost. In the attached example, I am looking for the cost for green small jeans, but I want the formula to still work if I switched the input to yellow large jeans.
![]()
=INDEX($E$5:$R$9,MATCH(B4,$E$3:$R$3,0),MATCH(C4,E5:R9,0))
Bookmarks