search data?
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! |
search data?
Any experts to comment this? Even it is not workable. Thanks.
"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! |
search data?
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 |
search data?
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 |
search data?
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! |
search data?
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. kyoshirou wrote: 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 -- Dave Peterson |
search data?
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 "Bob I" wrote: 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! |
All times are GMT +1. The time now is 08:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com