Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm not exactly sure of what you need, but would this work? If you give
your first row a name like rng1, and the second row a name like rng2, another Array formula (of the same size) might be like this... {=IF(Rng2="n",Rng1,"")} It should only display a "B" & "D". Not sure if you want a vba solution though thanks - been on holiday This formula returns an array where the positive matches are displayed and the negatives are a blank string, or 'FALSE' So I now need to strip out the FLASE/blanks and then copy the formula so the 2 poitives matches are displayed in adjacent cells. just a matter of....................... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Use array for lookup value, to return array of lookups | Excel Discussion (Misc queries) | |||
Lookup/Array Formulas | Excel Worksheet Functions | |||
table, index, array, match, lookup? | Excel Worksheet Functions | |||
V-Lookup, column index number indicator in table array | Excel Worksheet Functions | |||
Index/ Lookup formulas and fuzzy matching | Excel Worksheet Functions |