I am having some sort of mental block. I'm pretty sure there is a simple
answer to my problem, I'm just not seeing it.

OK, I have a spreadsheet that is 49 columns wide. (ouch) However, all this
data must be tracked. I do not have Access to simplify the issue.

I want to display the data in form view/format on a new tab in the same
workbook. We'll call the tabs Data and Display. All users will be able to
look at Display, perhaps even look up information via combo/list boxes,
print, but not edit. After Display is set up and functioning, I'll lock the
Display from editing without a password (locking I know how to accomplish).

I'm blocking on this:
After I create the Name drop down list, how do I get the other cells to look
at that cell and display corresponding data (like address, phone, etc)???

Then, can I have two or three drop down boxes that will all work in concert
with each other and the other fields? Here's what I mean: I want users to
be able to lookup a record by Name, Street Address, or Phone Number. I want
other information to be diplayed when any one of those things are selected
(like contact name, bank information, mailing address).

I have searched Help & Forums and it seems the answer must be too simple to
bother explaining - except I need it explained.