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.

"John H" wrote:

What is the error in the Range lookup
ie. Entering True or False

Tks
John