Hi,

Illustrative example of my problem:

I have a list of numbers and letters. How can I lookup the value " 1 " and
return the multiple results of z, a, g ? I want to type only one formula
in one cell, although I don't mind the result being spread out over multiple
cells.
Thanks for your thoughts on this.

1 z
2 b
1 a
3 e
4 f
1 g

See one of your other posts

--
Biff
Microsoft Excel MVP


"ORLANDO V" wrote in message
...
Hi,

Illustrative example of my problem:

I have a list of numbers and letters. How can I lookup the value " 1 "
and
return the multiple results of z, a, g ? I want to type only one
formula
in one cell, although I don't mind the result being spread out over
multiple
cells.
Thanks for your thoughts on this.

1 z
2 b
1 a
3 e
4 f
1 g

Sorry Biff but what post are you talking about ? The posting mechanism kept
timing out on me but this is the only post I see with a response.


"T. Valko" wrote:

See one of your other posts

--
Biff
Microsoft Excel MVP


"ORLANDO V" wrote in message
...
Hi,

Illustrative example of my problem:

I have a list of numbers and letters. How can I lookup the value " 1 "
and
return the multiple results of z, a, g ? I want to type only one
formula
in one cell, although I don't mind the result being spread out over
multiple
cells.
Thanks for your thoughts on this.

1 z
2 b
1 a
3 e
4 f
1 g