And if the first TRUE is in B3, would you then want to use the value in D3?

The solution I have in mind won't deal with such a table, a search in more
than one column I mean. But if you can put the whole thing not in A1:D9 but
in A1:<x18, there are a couple of ways you can solve this pretty easily.

Let's say your Boolean values are in A1:A18, and the desired results in
B1:B18. If you were to use =VLOOKUP(TRUE,A1:B18,2,0), what that'll do is
search down the left-hand column of the table you defined (A1:B18) until it
finds the value you said to look for (TRUE); when it finds it, it'll return
the value in the 2nd column. Will that do?

--- "Solar Man" wrote:
I thought I had this one licked. I have a list of TRUE FALSE cells. There
are 18 of them. Say they were listed A1:A9 and B1:B9 then if A! is TRUE,
insert contents of C1. If A6 is TRUE, insert contents of C6 and so on. Only
one of them will be TRUE at any time. I tried using multiple IF's but found
I could only enter 6 and then it wouldn't take any more. Is there a better
way to do this? Thank you in advance.