I have a table with the months from B1:M1 & Customers from A3:A35. B3:B35 are transaction numbers.
On another sheet, I have a cell, C2 with the name of the month that I type in, I've named it MONTH. I also have a seperate section for each customer that NBVC has helped me populate from another sheet based on MONTH and their actual transactions.
At the bottom of the section, I want it to populate from this other table based on the month in the MONTH cell.
I've created this formula, but it's not giving me the right information.
=INDEX('CTR''S 2008'!B3:M35,MATCH(MONTH,'CTR''S 2008'!B1:M1,0),MATCH($B$4,'CTR''S 2008'!A3:A35,0))
Bookmarks