Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
look up for values in the cells
Hi, I have a program and I want my user be able to look up a famyli name
instead of the whole name, I mean: A B Vazques Mota Frnacisco 1 Barrios Medina Alejandro 2 Concepción Báustegui Antonio 3 Andres Gustamante Berenice 4 Medina Arroyos Fernando 5 ................ ... 1. I want that the user put Vazques and returns the number 1 value 2. I think this question is a difficult one, but ¿What about if the user made a mistake and instead of Vazques he puts Vasques, There could be somehow the computer find the name??? TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
look up for values in the cells
GoTo www.J_Walk.com (Hi John!)
first look at the text parsing stuff to select the last name from a first/last combo ( buy puptools, plug, plug) then look at his soundex excel download as a way to work around name recognition and misspellings it's really impressive and cool Oh, and Vlookup cures the boring part "filo666" wrote: Hi, I have a program and I want my user be able to look up a famyli name instead of the whole name, I mean: A B Vazques Mota Frnacisco 1 Barrios Medina Alejandro 2 Concepción Báustegui Antonio 3 Andres Gustamante Berenice 4 Medina Arroyos Fernando 5 ............... ... 1. I want that the user put Vazques and returns the number 1 value 2. I think this question is a difficult one, but ¿What about if the user made a mistake and instead of Vazques he puts Vasques, There could be somehow the computer find the name??? TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
look up for values in the cells
THANKS, BUT i DIDN'T find the information in the given page
"Vacation's Over" wrote: GoTo www.J_Walk.com (Hi John!) first look at the text parsing stuff to select the last name from a first/last combo ( buy puptools, plug, plug) then look at his soundex excel download as a way to work around name recognition and misspellings it's really impressive and cool Oh, and Vlookup cures the boring part "filo666" wrote: Hi, I have a program and I want my user be able to look up a famyli name instead of the whole name, I mean: A B Vazques Mota Frnacisco 1 Barrios Medina Alejandro 2 Concepción Báustegui Antonio 3 Andres Gustamante Berenice 4 Medina Arroyos Fernando 5 ............... ... 1. I want that the user put Vazques and returns the number 1 value 2. I think this question is a difficult one, but ¿What about if the user made a mistake and instead of Vazques he puts Vasques, There could be somehow the computer find the name??? TIA |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
look up for values in the cells
My bad:
http://j-walk.com/ I have icon so missed the http "filo666" wrote: THANKS, BUT i DIDN'T find the information in the given page "Vacation's Over" wrote: GoTo www.J_Walk.com (Hi John!) first look at the text parsing stuff to select the last name from a first/last combo ( buy puptools, plug, plug) then look at his soundex excel download as a way to work around name recognition and misspellings it's really impressive and cool Oh, and Vlookup cures the boring part "filo666" wrote: Hi, I have a program and I want my user be able to look up a famyli name instead of the whole name, I mean: A B Vazques Mota Frnacisco 1 Barrios Medina Alejandro 2 Concepción Báustegui Antonio 3 Andres Gustamante Berenice 4 Medina Arroyos Fernando 5 ............... ... 1. I want that the user put Vazques and returns the number 1 value 2. I think this question is a difficult one, but ¿What about if the user made a mistake and instead of Vazques he puts Vasques, There could be somehow the computer find the name??? TIA |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
look up for values in the cells
Ok, now I have the correct address, but where to look for the information???
I didn't find the text article, please send me the complete adress TKS "filo666" wrote: Hi, I have a program and I want my user be able to look up a famyli name instead of the whole name, I mean: A B Vazques Mota Frnacisco 1 Barrios Medina Alejandro 2 Concepción Báustegui Antonio 3 Andres Gustamante Berenice 4 Medina Arroyos Fernando 5 ............... ... 1. I want that the user put Vazques and returns the number 1 value 2. I think this question is a difficult one, but ¿What about if the user made a mistake and instead of Vazques he puts Vasques, There could be somehow the computer find the name??? TIA |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
look up for values in the cells
Specific answer was in his book but this link will give you teh approach
look for first space, look for additional spaces return string following the first or last space Problem with "von Gristf" type last names http://j-walk.com/ss/excel/usertips/tip079.htm "filo666" wrote: Ok, now I have the correct address, but where to look for the information??? I didn't find the text article, please send me the complete adress TKS "filo666" wrote: Hi, I have a program and I want my user be able to look up a famyli name instead of the whole name, I mean: A B Vazques Mota Frnacisco 1 Barrios Medina Alejandro 2 Concepción Báustegui Antonio 3 Andres Gustamante Berenice 4 Medina Arroyos Fernando 5 ............... ... 1. I want that the user put Vazques and returns the number 1 value 2. I think this question is a difficult one, but ¿What about if the user made a mistake and instead of Vazques he puts Vasques, There could be somehow the computer find the name??? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
find values in multiple cells and paste row values | Excel Discussion (Misc queries) | |||
average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
conditional formating cells i Excel based on other cells values | Excel Worksheet Functions |