with true the lookup column has to be sorted since it will look for the
first value where your lookup value is greater than or eqqual to the value in
the column
for false, an exact match must be made. and an error is returned if there
is no match. sometimes the non match for cells which look alike is the
result of format issues.
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.
