search with autopopulate

Thanks for all help in advance!

I have a workbook that stores orders and customers. There is an initial worksheet that allows an order to be inputed. Off of this sheet I would like to be able to use a customer's last name and search letter by letter showing a drop down list of available customers to choose from. Once the customer has been chosen, I would like to autopopulate some basis customer information like first name, phone number, address, etc. So once a last name is chosen, it needs to remember that row in sheet2 as that is where all the rest of the information is stored, in that row.

One nice feature if possible would be when the drop down box shows the available last names to chose from, if it could also put the first name with each last name in that drop down box. I don't know if this is possible but it would be nice.

So here is some more specific info:

sheet1 = order sheet D5 is the last name cell that I would like to search from
sheet2 = already placed order sheet that I want to pull last name info from which is stored in the "I" column as in "Igloo"
sheet2 = first name is stored in H column

here is where things get tricky: here is a list of info that should be pulled from sheet2 to put in sheet1 when a last name is selected: (first cell references a sheet2 column with the specific row that was found above using last name added in and 2nd cell references sheet1 where that info needs to go)
G -> B4
H -> B5
J -> B6
K -> D6
L -> B7
M -> B8
N -> D8
O -> F8
P -> B9
Q -> E9

I hope this is possible, it would be really nice to be able to get this working, especially if it refreshed the drop down list as each last name letter is typed.

I'll buy you dinner if you ever come to gilbert az!

chip.

okay, so maybe that is too much to ask!

How about just a last name search that requires the entire last name entered and then brings up a list of matched last names from another column to choose from.