search data?

[Guest]

Hi Experts,
i do not know what should the subject be, but it seen to be something like
serch, therefore i put search data. Pardon if misunderstanings occur.

I have columns A,B,C,D,E, F,G,H,I,J with values below:
A B C D E F G H I J
1 2 4 5 6 1 2 0 nil 3A
2 2 6 6 9 2* 0 2 3 4AB
3 2 6 4 3 3 3 2 3 4AA

The SEARCH will work something like this:
users need to enter the value of from column F,G,H,I&J.
then reults match, the value of column A,B,C,D,E will shown.
Example: user enter 3,3,2,3,4AA, output will be 3264


Any ideas? it will best to make this more solid.
Thanks first!

 

[Guest]

Any experts to comment this? Even it is not workable. Thanks.

 

[Dave Peterson]

It seems like Data|Filter|autofilter would do what you want.

You can filter to show your values in F, then filter in G, ... through J.

If there are any visible rows, then those are all the records that match that
criteria.

 

[Guest]

Nope. That will going to create a long drop-down listing.
I refer if there's any better ways to do.

Thanks Dave!

 

[Bob I]

I think much easier to make it work with Access data base.

 

[Dave Peterson]

I can't imagine anything easier -- I guess you could spend lots of time trying
to build the same functionality, but that seems like a lot of work to me.

 

[Guest]

Hi Both,
I have managed to do it.
U guys can try CONCATENATE the number of columns into a new worksheet.
Follow by using VLOOKUP in the worksheet.

It works something like a search engine. It can help to trigger the exact
results when you have insert the actual values.


Cheers