in two different rows two different values which when concatenetated produce the same string. Since Im sure this sentence is unclear here are some pictures:
Capture.PNG
Clearly Im trying to find a combination 54 1, but it returns the row where a combination 5 41 is located.
Obviously excel match array functions in such a way that it concatentes the two searched values and then concatenates the rows from the lookup arrays and performes the search like that. This seems kind of amateurish. Anybody ran into this? Any solution? Kind of seems like a big deal if this is really so.
EDIT:
Attached an example excel file.
Expected behaviour: The value returned by match array formula in cell E2 should be 3, not 1.
Bookmarks