Hi all,
I've attached a small sample to demonstrate my problem.
Basically I have to consolidate 5 years of results which are shown in multiple and varying numbers of columns per month.
What I was trying to do is use an index match match array to pick up each sale amount for a customer that corresponds to the customer ID and the given month.
In the sample I've attached, I would want cell V5 to show a value of 5,781.41 (which are the three values for customer 1091 that occurred in Jul-19).
I can't work out how to pick up the first value in V5 and then pick up a second value in D5 followed by a third value in E5. Index Match Match picks up the first value. If I use Match +1 then I need to go through the data and work out how many month columns there are for each month. I have five years of data and this is something I need to create across several companies so hoping there is one array or formula which can find all corresponding values to Jul-19 for customer 1091 and so on for each month and each customer.
Bookmarks