Forum Discussion
CHOOSING A VALUE FROM HOMONYMS
Hello everyone.
I'm going crazy trying to find a formula that allows me to choose a certain value between homonyms.
I'll get into the specifics.
In the image below, in column A, I have Surname and Name, while in column B I have dates of birth, etc.
As you can see there are two namesakes but obviously they are different people since they were born on different days.
If then, as in the following image, I tried to insert in B12 the name that appears to be present twice in the previous table using the VLOOKUP formula it always returns the date of the first "ESPOSITO LUCIANO" (i.e. the one born in 2000) but I'm interested in including the second, that is, the one born in 1997.
How can I do so that I can choose the "ESPOSITO LUCIANO" that I want to insert?
I hope I have been clear in my explanation and request.
6 Replies
hi Luxio1997
There is a way to get both values, but only if there are two values.
This is in spanish, you have to translate to italian or english.
=UNIRCADENAS("-";VERDADERO;TEXTO(BUSCARX(K10;J4:J8;K4:K8;"activo";0;1);"dd/mm/aaaa");TEXTO(BUSCARX(K10;J4:J8;K4:K8;"activo";0;-1);"DD/MM/AA"))
This formula find the first match from first to last row, and the second find match from last to first.
The only way I discorvered.
kind Regards
