lookup

[dpaton05]

I have a table which has data I need for my spreadsheet. The table has two rows of headings on both X and Y axis. Is there a formula that will allow me to get data from this table?

 

[mrshl9898]

Pretty vague description, perhaps an INDEX(MATCH,MATCH)?

Any sample data and desired results?

 

[dpaton05]

Pretty vague description, perhaps an INDEX(MATCH,MATCH)?

Any sample data and desired results?

I worked out a way I could do it. I just listed all possible results and used SUMIFS formula to find the answer.

Thanks anyway.

 

[dpaton05]

I thought of index match match but I couldn't see a way it would work with the data I had.