Need something simple
 

I need something simple. I have tried understanding the functions, scripts,
etc...
All I want is something where I enter a name and all the information related
to that entry comes up. I have a template ready to use. Also have a spread
sheet with all the info. I am trying to set it up where others can just type
a name, hit enter, and the info comes up.

Need something simple
 

Have a look in help for VLOOKUP

See Debra Dalgleish's site for more on VLOOKUP.

http://www.contextures.on.ca/xlFunctions02.html

And possibly you want to have a dropdown menu for entering the names and
save on the typing errors.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP

On Sun, 17 Jan 2010 09:44:01 -0800, Hawkeyes
wrote:

I need something simple. I have tried understanding the functions, scripts,
etc...
All I want is something where I enter a name and all the information related
to that entry comes up. I have a template ready to use. Also have a spread
sheet with all the info. I am trying to set it up where others can just type
a name, hit enter, and the info comes up.

Need something simple
 

Look under VLookup in Help. Otto

"Hawkeyes" wrote in message
...
I need something simple. I have tried understanding the functions,
scripts,
etc...
All I want is something where I enter a name and all the information
related
to that entry comes up. I have a template ready to use. Also have a spread
sheet with all the info. I am trying to set it up where others can just
type
a name, hit enter, and the info comes up.

Need something simple
 

You don't necessarily need code for this.

If your table of data is on a sheet called myDataSheet and starts with
headings in row 1 and data from row 2 :
Name Address Phone etc.
A 123 Mill 01189 Other
B 567 Ave 12345 Extra
etc.

Then on your summary sheet
Name the name entry cell as follows :
Name myName - {entered by user}

Then put calculations on your summery sheet as follows :
Address
=index(match(myName,myDataSheet!A2:D100,FALSE),myD ataSheet!B2:B100)
Phone
=index(match(myName,myDataSheet!A2:D100,FALSE),myD ataSheet!C2:C100)
Etc.
=index(match(myName,myDataSheet!A2:D100,FALSE),myD ataSheet!D2:D100)

The 100 listed above will need to be amended to the last row of your data
When you change the name on the summary sheet, the rest will change with it.

The alternative is to use vlookup instead of index and match - depending on
the size of your file, index and match works slightly quicker

Thirs option is to use INDIRECT() but is a bit clunkier
--
If the post is helpful, please consider donating something to an animal
charity on my behalf.


"Hawkeyes" wrote:

I need something simple. I have tried understanding the functions, scripts,
etc...
All I want is something where I enter a name and all the information related
to that entry comes up. I have a template ready to use. Also have a spread
sheet with all the info. I am trying to set it up where others can just type
a name, hit enter, and the info comes up.