Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have attempted to using MATCH & VLOOKUP to match search for matches.
For no apparent reason, I'm getting matches in some cases when I should and in others the matches fails (#NA result). If I look at the cell values compared, they SHOULD be matching. There are no unprintable characters in the comparison cells. Note also that I've set the parameters for MATCH and VLOOKUP correctly to indicate unsorted list (0 & false, respectively). I'm searching on 10 digit numbers. In some cases, I can get the function to work correctly if I wrap the search value w/ the TRIM() function. In others, I can get it to work if I divide the search value by 1 ( match(a3/1,...) ). Rather nonsensical, but maybe that's a tipoff to some of you? Any ideas? |