Purpose: to compare values from column ‘unknown’ to values from column ‘directory’ and to return corresponding value from column ‘name’.
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!
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.
PLEASE NOTE: same thread exists in the following forums:
Bookmarks