INDEX match not working

Hi guys,

I have an index match function which has worked for a lot of rows but not some - see example of the formula in the screenshot. Can anyone please advise?

Thanks!

see bottom right hand corner: =INDEX('Panel Actions'!$K$2:$K$35,MATCH($P27,'Panel Actions'!$A$2:$A$35,0))

The Panel Actions sheet actually has data going into row 37 - but the data above suggests it goes to 35? If I change the number 35 to 37, it says 'REF#'!

We cannot tell anything from the screenshot. we need to see an excel sheet.

As per your screen shot. I think the problem is due to merging of cells.
We will confirm only after seeing of actual file.

Hi
Please see spreadsheet attached!
Thanks!

The column range wasn't long enough. Just use this:

=INDEX('Panel Actions'!$K:$K,MATCH($P2,'Panel Actions'!$A:$A,0))

or at least use a range that is future-proof

this works, thanks Glenn!

this could work too. But I`ll future proof it like Glenn said. Thanks John!

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.