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)

 

[Fluff]

Are you looking for exact matches?

 

[lost_in_the_sauce]

Are you looking for exact matches?

I should be, but if I switch the match type to 0 I get N/A

 

[Fluff]

That suggests that one of the two matches is not finding anything.

 

[lost_in_the_sauce]

That suggests that one of the two matches is not finding anything.

If the first row is good, then I'm guessing it's the column match?

 

[lost_in_the_sauce]

Is there a way to troubleshoot just that match?

 

[Fluff]

You can use the Evaluate Formula button on the Formula tab to see which Match is failing.

 

[lost_in_the_sauce]

For the cells on the first row, after clicking Evaluate twice, the first match changes to *1*, but the one below it changes to *188*

 

[lost_in_the_sauce]

The good news is I fixed it and broke it in a different way

 

[Fluff]

In what way?