RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 790
- Office Version
- 365
- Platform
- Windows
Hi guys
Comparing long chains of numbers, where say, the first 10 digits of the lookup value and the array they are stored in match, however the right side of the digits don't match for whatever stupid reason.
Anyway to do an index match that's like...
?
Cheers!
For further clarification, the string of numbers is 17 digits long, but only the first 15 digits match. For some god-forsaken reason on one sheet they all end with a 0, and on the other it's a random digit.
Comparing long chains of numbers, where say, the first 10 digits of the lookup value and the array they are stored in match, however the right side of the digits don't match for whatever stupid reason.
Anyway to do an index match that's like...
Excel Formula:
Index([answer column],match(left([Lookup value],10),left([lookup array],10),0))
Cheers!
For further clarification, the string of numbers is 17 digits long, but only the first 15 digits match. For some god-forsaken reason on one sheet they all end with a 0, and on the other it's a random digit.