The False means that an exact match must be made between the lookup value
(A2) and the lookup range an error will be the result if there is no match.
advantages of this are that when you must have an exact match you can force
it. also the lookup table does not have to be sorted before it works.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
