Hi All,
I have been looking all over the posts for the answer but I cannot find the answer, here is my problem;
Every month I get a sales report and the columns move around but the data consistent no new columns just different order and what I do is a summary front sheet. I cannot use one formula as the template seems to change and the columns as mentioned.
So is there a way to find which column (column header names stays the same) has the product (it can be in that column multiple times) and then find the relating sales column and corresponding sales figure and then sum up the total sales of that product. The main problem for me is the columns always moving around so cant fix a formula to column address.
I hope that makes sense.
Bookmarks