Biff,
Thanks for the solution. It works as advertised.
I am trying to undersand the logic.
Is the first "2" Boolean (i.e. "False")?
Is the first "1" Boolean (i.e. "True")?
The formula seems to work whether the "1" is a "1" or a "2."
If you have a moment, could you explain how this works?
(Always trying to improve my Excel logic skills.)
Thanks.
Scroll (about half way down the page) to this section:
#012 - Using A Non-Array LOOKUP Formula
It explains how the basic formula works.
Biff
Ask a Question
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.