Hello,

I have a table which has the customer name on the right, and then months in the columns. With units filling in the values section.

I would like to be able to add a formula that says "X customer last ordered in May".

I was thinking of doing an Index, match but I am not sure what to put in the match. Customer Ordered.JPG With the index pointing towards the column name of months.

Thanks!