Thread: using MATCH inside of an INDEX formula

Hi

I'm using the formula below in, say, cell X3 in a particular sheet:

=INDEX(X11:AC11, MATCH(1.05,X11:AC11,0))

This is just to check cells X11 to AC11 for the number 1.05, and then return me 1.05 in cell X3. What I wanted to know is, is it possible to change this formula in any way so that if 1.05 appears twice in cells X11 to AC11, then the formula will give me 1.05 multiplied by 1.05, instead of just 1.05?

Thanks

Do you perhaps mean:

=1.05^COUNTIF(X11:AC11,1.05)