| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
An Array Lookup Formula
We need to write array formulae that return all occurrances of a lookup value
in a lookup array instead of just the first occurrance. For example: Col. A Apples Apples Pears Oranges Apples Oranges Plums Pears Col. B 2 bushels 4 bushels 1 bushel 2 bushels 3 bushels 2 bushels 5 bushels 3 bushels We want array formulae in columns D & E to pull all the pears and their corresponding quantities: Col. D Pears Pears Col. E 1 bushel 3 bushels Any suggestions?? Thanks in advance! -- Susan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i need help with a lookup and/or array type formula | Excel Worksheet Functions | |||
| Array formula combined with Lookup | Excel Discussion (Misc queries) | |||
| Array formula lookup | Excel Worksheet Functions | |||
| Lookup Array Formula | Excel Worksheet Functions | |||
| Two-Way Lookup Array Formula | Excel Worksheet Functions | |||
Threaded Mode
