Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data Search | Excel Discussion (Misc queries) | |||
Data Search | Excel Worksheet Functions | |||
Search through Data | New Users to Excel | |||
Search for data using 'contains' | Excel Discussion (Misc queries) | |||
Search data formulas - HELP!! | Excel Worksheet Functions |