lost_in_the_sauce
Board Regular
- Joined
- Jan 18, 2021
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
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)
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)