Formula Help with Lists

T

TN.Jim

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
 
V

Vacation's Over

Not sure of the logic you are looking for..
Is this it:?
You want a user to type "boy" and be offered the available list of boys?
User selects from list and ends "transaction"????
 
T

TN.Jim

I am not sure what you are asking...
I want the user to type "Boy" and have a list of boys displayed in the
following rows
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top