| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula Help with Lists
I need to be able to pull a list from series of data without sorting or
filtering... Example: A1 B1 Jim Boy Ann Girl John Boy Tina Girl Then if I Type "Boy" in cell A6, I can use =index(A1,match(A6,B1:B4,0)) to get "Jim" in A7 but how can I get John in A8? 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 | |||
| Conditional Formula w/Lists | Excel Worksheet Functions | |||
| help with formula and lists | New Users to Excel | |||
| Formula Help with Lists | Excel Worksheet Functions | |||
| Array Formula? Lists? | Excel Worksheet Functions | |||
| Referencing lists in a nested IF formula | Excel Worksheet Functions | |||
Threaded Mode
