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

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!