If I name an array G2:G90 Used and a second array H2:H90 Allowed and put
logical values in these columns then I should be able to use the AND
function but it gives me the wrong answer.

For example, say G3 = TRUE and H3 = TRUE and I put the following formula in
I3:

= AND(Used, Allowed)

I expect to see TRUE in I3 but I get FALSE.

Thanks,
Karl
kwb AT dcm-va.com