But, it doesn't. I am going to suggest you take the challenge and try to use this single step method. I think the reason this is so difficult is that you are using two functions which you probably never used before. So, let me break it down into two pieces. This is a horribly named function.
Index requires three arguments.
Actually, this piece of it seems so trivial that it seems useless. The sticky note on my wall actually shows it as two lines. The first few times I had to do one of these, I was tempted just to slam a new temporary column A in there, but went through the pain of doing it this way instead. It is faster, and requires less manipulation. Consulting can be hired to implement this concept with your data.