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,
![](/board/proxy.php?image=https%3A%2F%2Fi.postimg.cc%2FTprXGsPz%2FScreen-Shot-2018-12-02-at-22-13-30.png&hash=62a8a5087351a116d040afaba1322906)
![](/board/proxy.php?image=https%3A%2F%2Fi.postimg.cc%2FG9t2Lb0Z%2FScreen-Shot-2018-12-02-at-22-09-08.png&hash=8725f73511cfae67588680690974e37b)
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,
![](/board/proxy.php?image=https%3A%2F%2Fi.postimg.cc%2FTprXGsPz%2FScreen-Shot-2018-12-02-at-22-13-30.png&hash=62a8a5087351a116d040afaba1322906)
![](/board/proxy.php?image=https%3A%2F%2Fi.postimg.cc%2FG9t2Lb0Z%2FScreen-Shot-2018-12-02-at-22-09-08.png&hash=8725f73511cfae67588680690974e37b)