Excel Customer Form
 

does anyone know if there is a way to set up an excel sheet so if i type in a customer name, the information pertaining to it shows up. This is what I mean. I am doing it in Microsoft Excel

Say I type in John Deere
I want it to make the address, phone number, contact, fax#, and other information to automatically appear.
Is this possible to do.
I hope you understand what I am trying to say. Thank you in advance

edit
 

That would be very possible!

You could format the columns for the size of the font that would work with the same size used for the rows, or narrow the rows, then enter a header and font for each column, size each column, enter a formula that tells the cells (yr u) locked into using excell?

There are several utilities and major programs out there to do this. Don't recreate the wheel my friend.

Maybe if you gave more criteria.

There are several database guru's on the TFP.

I am not one.