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

look up for values in the cells
 

The first part, it is not difficult. You have all three names in one cell.
FIrst take the data from column B and move it to column D. Next select
column A and pull-down

Data Text to Columns... and use the space as the separator.

This will take the names from column A and split them into columns A, B, and
C.

Since the family name is alone in column A, you can use the VLOOKUP()
function to find it.

I don't know how to solve the problem of mis-spellings.
--
Gary''s Student


"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