| 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
Try VLOOKUP with range_lookup set as TRUE. This will return the first
closest match. "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 | |||
Linear Mode
