| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup values vertically in a list and return the repeats | Excel Worksheet Functions | |||
| only return true values | Excel Discussion (Misc queries) | |||
| Lookup a value in a list & return multiple corresponding values | Excel Worksheet Functions | |||
| trying to lookup a value and return if true or fals | Excel Worksheet Functions | |||
| Lookup values in a list and return multiple rows of data | Excel Worksheet Functions | |||
Threaded Mode
