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
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)
Somebody pls help
- 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)
Somebody pls help