Need something simple

[Hawkeyes]

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.

 

[Gord Dibben]

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

 

[Otto Moehrbach]

Look under VLookup in Help. Otto

 

[Paul]

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!A2100,FALSE),myDataSheet!B2:B100)
Phone
=index(match(myName,myDataSheet!A2100,FALSE),myDataSheet!C2:C100)
Etc.
=index(match(myName,myDataSheet!A2100,FALSE),myDataSheet!D2100)

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