G
Guest
I have several repeating text chains values in a columm which I want to link
whith other values stored in the same sheet but different cells.
To make this clearer, I have several initials in a colum (JR; AN; etc.) and
I want to search for these in another table where other attributes such as
full name, phone number, e-mail, etc. are adjacent. By doing so I expect to
replicate this values on the main table and be able to change a set of them
by modifying only the one contained in the cell as I could do with a
database.
To get this, I have used function "BUSCAR" (I have the spanish edition, so I
think this must be something like "SEARCH" on the english one). The problem I
have found is that this function makes a mistake when trying to identify the
initials and confusses them sorting erroneous values.
Could any of you please help me? Thanks very much in advance!
whith other values stored in the same sheet but different cells.
To make this clearer, I have several initials in a colum (JR; AN; etc.) and
I want to search for these in another table where other attributes such as
full name, phone number, e-mail, etc. are adjacent. By doing so I expect to
replicate this values on the main table and be able to change a set of them
by modifying only the one contained in the cell as I could do with a
database.
To get this, I have used function "BUSCAR" (I have the spanish edition, so I
think this must be something like "SEARCH" on the english one). The problem I
have found is that this function makes a mistake when trying to identify the
initials and confusses them sorting erroneous values.
Could any of you please help me? Thanks very much in advance!