What I need to do is extract the Value from the "ending" column based on the matching BE, Major, and Sub. For example, given BE: 02, Major: 22, Sub: 12 I would want the cell to return the value $90000. Is there a way to do this without using a lengthy Index/match formula? Perhaps through the use of some level of filtering or pivot tables? I can't seem to get past a formula approach but want to avoid the use of a ridiculously long formula if possible.