Purpose: to compare values from column "unknown" to values from column "directory" and to return corresponding value from column "name".
There is one condition:
My solution is to Truncate them to the 3rd decimal and try three vlookups - real, +0.001, -0.001
If you have another solution please let me know!
The file is shared here
Tried both VLOOKUP and INDEX/MATCH and both return the same result:
PROBLEM
No match found in ROW 184. However, you can see visually in row 184 column C (named 'unknown') the value is 444.383, and when I look it up it in column I (which is 444.383+0.001) should return a match as there is a value 444.384 in column A ('named directory').
Why on row 184 neither VLOOKUP or MATCH/INDEX are NOT working?
Obviously there might be more matches, which are not shown.
There is one condition:
- The numbers from the 'unknown' column must be looked up +/-0.001
My solution is to Truncate them to the 3rd decimal and try three vlookups - real, +0.001, -0.001
If you have another solution please let me know!
The file is shared here
Tried both VLOOKUP and INDEX/MATCH and both return the same result:
- 26 matches for columns for the original number truncated to 3rd decimal (columns D, E, F)
- 60 matches for the number truncated to 3rd decimal +0.001 (columns H, I, J)
- 5 matches for the number truncated to 3rd decimal -0.001 (columns L, M, N)
PROBLEM
No match found in ROW 184. However, you can see visually in row 184 column C (named 'unknown') the value is 444.383, and when I look it up it in column I (which is 444.383+0.001) should return a match as there is a value 444.384 in column A ('named directory').
Why on row 184 neither VLOOKUP or MATCH/INDEX are NOT working?
Obviously there might be more matches, which are not shown.