LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
 
Posts: n/a
Default When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)...

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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 07:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"