Hello, I am trying to figure out a way to make a database and I was hoping
someone could help me with a snag I hit. I am trying to create a database in
Excel. It will basically have two sheets.

One for all of the information, and the other to act as a sort of search
function. The sheet with all of the information will have several columns,
including a persons name, clothing size, shoe size, etc. What I want on the
second sheet it to be able to type the persons name (which will be column A)
and be able to search the database and show all of the information in the
rest of the columns. (For example, the name in column A2 is Joe and there are
three other columns. The search would return all of the information in
columns B2, C2 and D2)

I know that there is a way to do this, but my experience in programing with
Excel is somewhat limited. Is there anyone that can help or at least point me
in the right direction? Any help would be greatly appreciated. Thank you.