vlookup retunrning a match, when not a match...
 

<I DID post my formula

Yes, you did. Sorry, I overlooked it.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"mark" wrote in message ...
|I DID post my formula, and no, I didn't omit the 4th argment. FALSE is the
| same to Excel as 0, which is what I used.
|
| That is NOT the answer.
|
| When I switch the fourth parameter to FALSE, not 0, it gives exactly the
| same problem.
|
| "Niek Otten" wrote:
|
| Always post your formula.
|
| Perhaps you omitted the 4th argument to VLOOKUP? It should be FALSE
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "mark" wrote in message ...
| |I have two item numbers:
| |
| | 61*80*C51*022 in a list of item numbers, tblList
| |
| | 61*080*C51*022 in a single cell, call it a1
| |
| |
| | the function =vlookup(a1,tblList,1,0) is returning a match on that.
| |
| | they are not identical... one is *80* , the other is *080* .
| |
| | I think it's because of a wildcard search that it's calling it a match?
| |
| | I need it to be able to distinguish the difference. It's causing my report
| | to be wrong.
| |
| | Help?
| |
| | thanks.
| |
|
|
|