0
251
VistasExtract value if first characters match text in a range of cells
I have a table with the following formula:
=IF(SUMPRODUCT(-- (LEFT(A1:D1,5) = "__FTC")),"Exists", "No Exist")
It successfully detects if the first 5 characters contain the word "__FTC" as shown on column E.
I need to get the value instead of just detecting if the value exists as shown below:
·
Santiago Trujillo
1 Respuestas
Responde la pregunta0
Use INDEX/MATCH:
=IFERROR(INDEX(A1:D1,MATCH("__FTC*",A1:D1,0)),"")
·
Santiago Trujillo
Denunciar
Responde la pregunta