Match function seems to be returning from within a formula?-CodePudding

Home > Back-end > Match function seems to be returning from within a formula?

Match function seems to be returning from within a formula?

Time：05-20

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: