Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search and expand featu programming
I have a sheet in excel with a list of people and their wages. On another sheet, I would like to start typing the name of the person and have something like an auto-complete feature from the list of people and their wages, so that I can easily pick the person I want. How can this be done in excel? Thanks a lot for your help, --j |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
search and expand featu programming
Hi John!
One way is use VLOOKUP-function. Regards, Kari J Keinonen |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
search and expand featu programming
no, but you can pick the name from a list using data =Validation.
to use an offsheet list as the source, you would first have to create a named range (insert=Name=Define) that refers to it, then use that name range as the source of your data validation. -- Regards, Tom Ogilvy "John" wrote in message ups.com... I have a sheet in excel with a list of people and their wages. On another sheet, I would like to start typing the name of the person and have something like an auto-complete feature from the list of people and their wages, so that I can easily pick the person I want. How can this be done in excel? Thanks a lot for your help, --j |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search and open feature | Excel Programming | |||
How do I expand Excel lookup function to search more than 16,384 r | Excel Programming | |||
Search feature not too helpful | Excel Discussion (Misc queries) | |||
Search feature in workbook | Excel Worksheet Functions | |||
Search feature | Excel Programming |