Quote:
Originally Posted by Plan9 
If it were me, I'd change the cell reference to LEFT(cell, 3) to only pick up the first 3 characters and then change FALSE back to TRUE. So your formula would look something like:
=VLOOKUP(LEFT(cell, 3), A1:B3, 2, FALSE)
Personally I don't trust fuzzy matching as there's a theoretical chance it could do an incorrect match (and after a while you'll get complacent thinking the formula works so might not notice an error in the match). By forcing an absolute match then you know that your results will always be correct.
If it were me, I'd change the cell reference to LEFT(cell, 3) to only pick up the first 3 characters and then change FALSE back to TRUE. So your formula would look something like:
=VLOOKUP(LEFT(cell, 3), A1:B3, 2, FALSE)
Personally I don't trust fuzzy matching as there's a theoretical chance it could do an incorrect match (and after a while you'll get complacent thinking the formula works so might not notice an error in the match). By forcing an absolute match then you know that your results will always be correct.
Ok, so I have this;
Code:
=VLOOKUP(D14, Building, 2, TRUE)
// D14 is the cell being referenced for the building designator character.
Would something like this work?
Code:
{=LEFT(D14, 3) & VLOOKUP(D14, Building, 2, TRUE)}
had a fatal error.
(14 items) |
|
had a fatal error.
(14 items) |
