Index Match Match Row 1 fine, rows 2 and beyond wrong numbers

[lost_in_the_sauce]

Current formula is: =INDEX(TabOne!$G$4:$AT$191,MATCH('TabTwo'!$A2,TabOne!$A$4:$A$191,1),MATCH('TabTeo'!B2,TabOne!$G$3:$AT$3,1))

TabOne is a table with revenues, store name in column A and dates (EOMonth style) in row 3.

TabTwo is attempting to pull a specific cell value, based on store start date in column E on TabTwo. Goal is to replicate across and down to have all cells in row E of TabTwo reference the first month sales from TabOne's array, with different starting months of course.

Row 1 works great. Rows 2 and on I can't understand where the numbers are coming from (row 2 is zeroes, row 3 and 4 replicate row 1)

 

[lost_in_the_sauce]

references are working but still going all over the place, I swapped back to the original data sheet instead of the truncated one I made

 

[Fluff]

In that case can you post some sample data.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[lost_in_the_sauce]

Oh yeah, I heard of it before. I got it working, the evaluate formula really helped - I figured it was shooting things to the wrong rows for some reason

 

[Fluff]

Glad you sorted it & thanks for the feedback.