Lookup list, populate cells

[x65140]

I want start entering a name in COL A, and it looks up the name list on SHEET2 - then populates SHEET1 A,B,C with the results.
The name list on sheet2 is sorted, but may have the SAME NAME, but a different state, so I want to be able to select either.

EX: I type "JOH", and it displays "JOHNSON,PAT TX", "JOHNSON, PAT WA"

Attached sample...

[AB33]

I am not sure where the results are copied, but I copied them in to column F.

[AB33]

If you want to display the result in column A

Change the F in to A in this line

Please Login or Register  to view this content.

[Fotis1991]

1 way could be something like this.

Please Login or Register  to view this content.

[x65140]

Can't get it to work. Maybe I didn't explain it well enough. I'm uploaded another sheet (called NEWLOOKUP) with what I hope is a better explanation.

[AB33]

You have not explained why my code does not work the way you wanted it.
It has displayed all the search cells, but I am not sure when you say, I choose? How do you choose out of the options?

[x65140]

I opened your workbook. Typed JOH in cell A1 and nothing happened. What am i doing wrong? (apologize for my ignorance)

When I type JOH in cell A1, I was thinking that a list would appear, and maybe i could click on the name i wanted.
Then the cells A thru C on sheet 2 would populate A1:C1 on sheet 1

Then, I want to type a new search name in A2, then A3, etc....

[AB33]

Well, I know the issue. The first attached had row 2, not row1, so my search was based on A2, not A1.
No problem, I will adjust the code.
One more question. The search finds over two options, where do you want to list them? Is it A2:C2 and the rest?

[x65140]

if the search finds more than one option, is there a way for me to click on the one i want? if not, just return the first option to A1:C1

This code will have to work for all of column A.

THANKS!

[AB33]

The code assumes the search value is in A1, it then list all found items starting from A1. Which means it is going to erase A1,once the search value is found

[xwarlock10x]

Here you go.. This works.. Check sheet 2

[x65140]

appreciate all of your help...thanks.