'Match function seems to be returning from within a formula?

I am using this formula to find the relative position of the furthest right word "Move" in my cells.

=MATCH("Move",AG5:LM5,1)

The only problem is the cells in AG5:LM5 are using this formula:

=IF(LEFT(KV5,3)="Map","Move",FALSE)

The match function always seems to return the relative position of the farthest right entry, even if the farthest right entry is "FALSE".

Is there a way to fix this?

Edit:

Here is an example sheet:

https://docs.google.com/spreadsheets/d/15idQ0s3ljoPSroSPi-Rv-Dhh_Nm88Rj9hB8WmNdCYjI/edit?usp=sharing

For Test1 I want the location column to ignore the Recruit input and instead return the Map7.8 input. In Test2 I want it to pull the rightmost instance with "Map" in the input into the location column, this is acting as intended.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source