Index / Match

[elsaidmi]

I am trying to use Index Match to pull data totals into a summary sheet.

On the detail sheet, I have rows of orders (Order 1,2,3...), the columns have monthly Dates (Jan-15,Feb-15,Mar-15...). Each month with each order has a payments.

In the summary sheet I want to put a formula that will pull that number (I would be pulling only the total for that order so it is not repetitive) based on the Order I have in the row and the date that is in the column, so a two way match.

Maybe this can help you visualize the data...

-------------- Jan-15--- Feb-15 --- Mar-15
-------------- 10 ------ 7 ------ 100
-------------- 8 ------ 11 ------ 110

ORDER 1 --- 18 ------ 18 ------ 210




Summary Sheet
Order 1 Jan-15 Feb-15 Mar-15
-------------X

X= total from detail sheet (18)

 

[gaz_chops]

What are the data ranges for Detail sheet and the lookup ranges on summary sheet?

 

[elsaidmi]

What are the data ranges for Detail sheet and the lookup ranges on summary sheet?

You can assume they are all in the left top corner... but I'm really just confused on how to put the data into the formula. If you could suggest a way while writing things like "order total, date here" in the formula I can put it together. My computer doesn't let me send in images!

 

[gaz_chops]

try
=index(Data Sheet,match(Row Lookup Val,Data Sheet Col,0),match(Col Header Lookup Val, Data Sheet Row with Headers,0))