Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Help with Lists
I need to be able to pull a list from series of data without sorting or
filtering... Example: A B 1 Jim Boy 2 Ann Girl 3 John Boy 4 Mike Boy 5 Tina Girl 6 Matt Boy 7 Beth Girl Then if a user selects "Boy" in cell A8, I want A9 = "Jim" A10 = "John" A11 = "Mike" A12 = "Matt" I can use =index(A1:A7,match(A8,B1:B7,0)) to get "Jim" in A9 but how can I get John in A10 etc? The actual list is much more complicated but I hope that this gives an idea of what I need to do. Thanks for the help! Jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Array Formula? Lists? | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |