lookup 2 columns and 1 row to return a value from the table

**greglech** · 06-22-2012, 11:59 AM

Hi, I am new to the board, I was hoping someone could help me create a formula. I have a table, and I first need to lookup a value from 1 column with in the table, then, based off that value, I need to lookup a value in the next column, and then lookup a row, to retunr a value. My enclosed spreadsheet helps explain. I have used index/mtch in the past to lookup the column then row to return a value from the table, however, in my current problem, I have 2 columns of data i need to look up.

Thank you very much for any guidance/help

**NBVC** · 06-22-2012, 12:15 PM

Try this based on the inputs in A20:A22

=SUMIFS(INDEX($C$4:$F$15,0,MATCH(A22,$C$3:$F$3,0)),$A$4:$A$15,A20,$B$4:$B$15,A21)

**greglech** · 06-22-2012, 01:12 PM

That's Awesome !!!! Thank You so much. I wasted 2 hours this morning trying to figure this out ( even tried the "sumifs" but gave up on them). I substituted in my named ranges and it works great. And thank you for such a quick response.

Best Regards !!
greg