Hi Folks,

I'm trying to utilise an Index and Match formula to search for a particular value within a table range and then return it's corresponding footer value. I've look at some other threads on the forum and learned that the Match function doesn't seem to like arrays very much, so I was hoping someone could suggest an alternative?

I've attached a sample to give you a better idea of my problem.

Thanks in advance.