Reading/lookup Data from excel by giving a querry

Hi,
I am new to excel programming.
I have a excel sheet with two columns say for example

Name.....Address.
-----------------------
Scott.....California.
Tim........Michigan.
Mike.......NewYork.

Now, I would like to have a box where I can give desired name and lookup for its corresponding address.
If i enter Scott in a dialog box then it should display California, likewise

Is there a method to enter querry without opening the document.

can someone explain me how do i do this.

Thanks in advance.

helloexcel,

welcome to the forum

please see attached file. for the dropdown box and lookup

hope this helps

steve