Maverick27
Active Member
- Joined
- Sep 23, 2010
- Messages
- 329
- Office Version
- 2013
- Platform
- Windows
I need help troubleshooting 2 diff "Index Match Formulas" to find closest match btwn Col A & Col C of my worksheet ![Roll eyes :rolleyes: :rolleyes:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
The 2 functions I'm trying to troublesheet :
Unfortunately both functions are returning a result of "#VALUE!"
The expected result for closest match to 876-SCALE in A2 should be: 0876-SCALE (Row 5449 of Col C)
![](/board/proxy.php?image=http%3A%2F%2Fs2.postimg.org%2Ff4ihx4vhl%2Fclose.png&hash=d2556ac0bd217e94c953b724ee27b86c)
Somebody pls help![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
- The range in Col C is where I want to find the specific value.
- A2 is the searching value that I want to be compared with (Function to be copied across down the Col)
The 2 functions I'm trying to troublesheet :
Code:
[FONT=verdana]=INDEX(C2:C20000,MATCH(MIN(ABS(C2:C20000-A2)),ABS(C2:C20000-A2),0))[/FONT]
Code:
[FONT=verdana]=INDEX(A2:A10000,MATCH(TRUE,ABS(C2:C20000-A2)=MIN(ABS(C2:C20000-A2)),0))[/FONT]
Unfortunately both functions are returning a result of "#VALUE!"
The expected result for closest match to 876-SCALE in A2 should be: 0876-SCALE (Row 5449 of Col C)
![](/board/proxy.php?image=http%3A%2F%2Fs2.postimg.org%2Ff4ihx4vhl%2Fclose.png&hash=d2556ac0bd217e94c953b724ee27b86c)
Somebody pls help