Ghesselink
New Member
- Joined
- Jun 7, 2018
- Messages
- 20
Hello,
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:
=INDEX($B$2:$B$14,MATCH(P2,$B$2:$B$14))
Anyone got an idea why?
Thank you in advance for the help,
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:
=INDEX($B$2:$B$14,MATCH(P2,$B$2:$B$14))
Anyone got an idea why?
Thank you in advance for the help,