I tried to do an index match on the same column (the image below is an simplified example). Unfortunately, I tend to get strange outcomes but cannot see why. Only the '4643358' at Q9 seems to be working.
The formula I used was:
Anyone got an...