Standard Index formula to replace array?

[Cidona]

Dear Forum.
I’m able to produce the result I’d be looking for via an array formula that I was using for a different use (dragged down for multiple returns - thank you again benishiryo!), but I think for this new different need, since I’d only be looking for a single result I’d imagine there would be a nicer way of doing it with a regular INDEX formula or something (if I can eliminate unnecessary array formula that would be great as I also have quite a few array formulas for other uses in the workbook). While the sample workbook only has a single cell that would need said formula in the real world workbook there could be hundreds so if I can do without using array formula that would be great.
In the sample workbook I have my array formula that I’m looking to replace in Cell F18.
Would appreciate any insight!

[AliGW]

Try this in F18:

=INDEX($K$7:$K$11,MATCH("X",OFFSET($K$7:$K$11,0,F17),0))

If the numbers get changed to words, use this instead:

=INDEX($K$7:$K$11,MATCH("X",OFFSET($K$7:$K$11,0,MATCH(F17,$L$6:$X$6,0)),0))

[Cidona]

Thank you very much for your response!
You would think with such a nice short formula I couldn't mess it up, but maybe I have . it works fine in the sample workbook but not in the real world workbook. I have a feeling it is due to my layout being slightly different. (I may have over simplified). Can you please see screen shot of actual workbook where I'm trying your formula in DU161. Can you see how why it's not working for me?
Thank you again for your help.

[AliGW]

Attach a more realistic sample workbook - I cannot work with a screenshot. Over simplifying is never a good idea.

[Cidona]

Please see attached. Thank you.

[Glenn Kennedy]

I'm not sure about this, as there is no explanation about the second data set beyond column AW.

=INDEX($J$18:$J$24,MATCH("X",INDEX($O$18:$AQ$24,,MATCH($J$7,$O$17:$AQ$17,0)),0))

[Cidona]

That worked perfect Glen!! Thank you very much!! I'll owe you a Tanora

[Glenn Kennedy]

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.

[Cidona]

Ah! The "Thread Tools" method of marking of solved works so I have now been able to also mark my other two recent posts as solved as well as this. Previously I was doing it via the "Prefix" method by editing the original post but that wasn't working for me these last couple of day. (Another problem you solved Glenn. Thanks again!!

[Glenn Kennedy]

Woo Hoo. two for the price of one....