Now exact match not working...
I am uploading the example spreadsheet with a different issue noted in it.
I have changed a lookup to include the Lookup Argument of false, which means I want an exact match only in the lookup. But it is working as expected.
I have the falue of M* in the cell that is being looked up. But it is returning the value for M. What I think is happening is it is ignoring the *. I don't want it to do that.
The spreadsheet example is attached to this post.
Any thoughts?
|