Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Searching
i was wondering if someone could help me with a problem. i need to creat a
lookup that returns more than 1 result, for example. if i have a table with dan dave and duncan in, i can type d into a cell and it will bring up dan dave and duncan, if i type in da it brings back dan and dave, etc. i will be greatful to anyone who can help. |
#2
|
|||
|
|||
On Sat, 24 Sep 2005 09:43:01 -0700, "DQ05"
wrote: i was wondering if someone could help me with a problem. i need to creat a lookup that returns more than 1 result, for example. if i have a table with dan dave and duncan in, i can type d into a cell and it will bring up dan dave and duncan, if i type in da it brings back dan and dave, etc. i will be greatful to anyone who can help. What result are you expecting? A lookup will return one consistent value only. Seems like what you probably want is an Autofilter on the table, and then use the Custom 'begins with' on the name field and then enter your text string to filter the table. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching for "?" | New Users to Excel | |||
Searching for variables in excel database | Excel Discussion (Misc queries) | |||
Searching the first name only | Excel Discussion (Misc queries) | |||
3d range searching | Excel Discussion (Misc queries) | |||
Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) |