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

Thanks Dave!

"Dave Peterson" wrote:

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.

kyoshirou wrote:

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!

--

Dave Peterson