INDEX MATCH ARRAY formula not working|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi,

I have the following formula that works:

={MATCH(TRUE,$E3:$J3="-",0)}

However, when I try to make the column and row references dynamic using INDIRECT then the formula returns an error:

={MATCH(TRUE,INDIRECT($N$1 & ROW() & ":" & $O$1 & ROW())="-",0)}

($N$1 contains the letter "E" and $O$1 contains the letter "J" and I am entering the formula using CTRL+SHIFT+ENTER)

Can INDIRECT and MATCH be used in this way? Or have I got the formula wrong in some way?

Thanks for any help in advance.

Graham