| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need help with a downloaded template that was shared by steve
I downloaded and Address Book 1 template shared by steve and I love the
functions, but I can't change cells because the workbook is protected. I really want to use this address book because it has a sheet for data and a sheet for the address book that you can pull up the name of your contact from a dropdown box and then all of the rest of their information also is loaded. I have tried to do this in a new workbook and I created the dropdown box, but I can't figure out how to get the rest of the information to load. Can anyone help me with this? -- Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help with a downloaded template that was shared by steve
=VLOOKUP(A1,Sheet2!A1:B3,2,0) may be the answer.
Where A1 on the first sheet is the drop down of names and on sheet two column A is a list of the names and column B is a list of the address/information HTH Regards, Howard "mohrbaskets" wrote in message ... I downloaded and Address Book 1 template shared by steve and I love the functions, but I can't change cells because the workbook is protected. I really want to use this address book because it has a sheet for data and a sheet for the address book that you can pull up the name of your contact from a dropdown box and then all of the rest of their information also is loaded. I have tried to do this in a new workbook and I created the dropdown box, but I can't figure out how to get the rest of the information to load. Can anyone help me with this? -- Thank you |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
need help with a downloaded template that was shared by steve
Check out the below link on "Excel VLookup Function and VLookup Example"
by Debra Dalgleish . You can also download a sample workbook. http://www.contextures.com/xlFunctions02.html If this post helps click Yes --------------- Jacob Skaria "mohrbaskets" wrote: I downloaded and Address Book 1 template shared by steve and I love the functions, but I can't change cells because the workbook is protected. I really want to use this address book because it has a sheet for data and a sheet for the address book that you can pull up the name of your contact from a dropdown box and then all of the rest of their information also is loaded. I have tried to do this in a new workbook and I created the dropdown box, but I can't figure out how to get the rest of the information to load. Can anyone help me with this? -- Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a template shared by Steve and can't figure it out | Excel Worksheet Functions | |||
| Problem with downloaded template | Excel Worksheet Functions | |||
| How do i convert a downloaded template to UK | Excel Discussion (Misc queries) | |||
| downloaded template | Excel Discussion (Misc queries) | |||
| When I download template where should it be downloaded to and sav. | New Users to Excel | |||
Hybrid Mode
