Combining Index, small, if, row. Working until more data added

[Translationguy]

Hi All

I'm running into a bit of an issue I can't work out, granted I have a horrible cold right now... I did post this before but there are no answers to it, and searching the forums it doesn't show up..

I have this formula to find content in a sheet called "Test", it works perfectly until later:
=INDEX(Test!F:F,SMALL(IF($AX$92=Test!E:E,IF(A150=Test!B:B,ROW(Test!E:E)-ROW(Test!E1))+1),2))



What I want it to do/does is, search the Test sheet for:

• English keyword in E
• "Portugal - BGP" in B
• When there's a match, return the result from column F (other languages' keywords)
  • In this instance, skip the first result and instead give me the 2nd result

This is working fine, until I start adding more languages underneath. Once I add the Spanish keywords, it no longer functions correctly. My mind is a bit foggy right now, but I can't understand why it works until more content is added under.

Any help would be massively appreciated!

 

[Fluff]

Duplicate to: Combining Index, small, if, row

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.