CHOOSING A VALUE FROM HOMONYMS

Brass Contributor

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

Re: CHOOSING A VALUE FROM HOMONYMS

on my side.return 01/20/97

Re: CHOOSING A VALUE FROM HOMONYMS

if you want both

 2000-05-16,1997-01-20

=TEXTJOIN(",",TRUE,FILTER(TEXT(B1:B2,"e-mm-dd"),A2:A2=A4))

Re: CHOOSING A VALUE FROM HOMONYMS

I would like that when I enter a name, if it is already present, it should give me the opportunity to choose the one with the date of birth I choose.

Re: CHOOSING A VALUE FROM HOMONYMS

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.

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