Finding data using wildcard


Posted by Thirty on April 05, 2001 9:17 AM

Let say. I have 2 sheets in my workbook
Sheet 1 is to fill in data. while in sheet 2
is like a search engine for find data
In sheet 1. I use A1:C10 to fill data which
is in column A is for names , column B for
identity card and column C for adress.

How can in sheet 2 when I type a* , it will
display all the names starting with a with
their particular details. Let say in sheet 1
there are 3 names starting with the alphabet a,
how can i display it in sheet 2 by typing a*
and show the peoples with a names with their particular
details(identity card and addresses)

Thanks in advance

Posted by Dave Hawley on April 05, 2001 2:31 PM


Hi 30

It's sounds like you are after a Combobox linked to a cell and the have a VLOOKUP formula use that cell to return the information. See:
13870.html
About my posting to George on ComboBoxes and Dynamic Ranges.

Dave


OzGrid Business Applications



Posted by Aladin Akyurek on April 05, 2001 2:51 PM

A completely formula-based solution is also possible. It's rather complex, whence, I fear, less interesting.

Aladin