View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
robbie robbie is offline
external usenet poster
 
Posts: 26
Default lookup to return true() values only and list

Hi
i have column a1 : a10 with true() or false() values. Column b1 : b10 I have
text eg A, B C - J.

In column C, if a1 : a10 is true() then b1 : b10.

The problem I have is if only 3 values are true() I need to have the 3
values in C1, C2, C3

ie if a3 = true() then in c1 "C", a10 = true() then c2 = "J"

Hope you can help

Regards