An Array Lookup Formula
Why not just filter on Pears?
"SueDot" wrote:
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
|