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.
Bookmarks